Re: Oracle 7.2 Year2000 & Medium dates

Mike - in the init.ora file we have this command:

NLS_DATE_FORMAT = "MM/DD/RR" I think to get it into your format you would do:

NLS_DATE_FORMAT = "DD-MON-RR" Good Luck

Mike Desson wrote:
>
> Can anyone provide a detailed solution on how to set Oracle7.2 properly to
> have dates entered in medium date format (01-Oct-20) interpretted as
> 01-October-2020 instead of 01-October-1920.
>
> Apparently it's possible without reprogramming but we're having problems
> maling it work.
>
> We have been told to add a line to config.ora NLS_DATE_FORMAT=DD-MON-RR
> and that the maximum date is 01-jan-37 (2037).
>
> Then we heard that the statement was NLS_DATE_FORMAT=DD-MON-RRRR and the
> maximum date is 31-Dec-36.
>
> Does anyone have it workling properly and will you send us some info on how
> to do it properly?
>
> Please respond to mdesson_at_staftrak.com
>
> Thanks,
> Mike
  Received on Tue Oct 21 1997 - 00:00:00 CDT