Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle 7.2 Year2000 & Medium dates
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 Sat Oct 18 1997 - 00:00:00 CDT