Re: Oracle 7.2 Year2000 & Medium dates

From: William LEE <william_at_alumni.cuhk.edu.hk>
Date: 1997/10/19
Message-ID: <62g6ul$nc6@hpg30a.csc.cuhk.edu.hk>#1/1

You may set the default date format to 'DD-MON-RR'. You may set this in all the clients by:

For 16-bit clients, put "NLS_DATE_FORMAT=DD-MON-RR" in the file ORACLE.INI For 32-bit clients, put "NLS_DATE_FORMAT=DD-MON-RR" in the registry.

--

William WW LEE.
E-Mail: william_at_alumni.cuhk.edu.hk
***********************************

Mike Desson wrote in message <01bcdbde$5bd5eb60$4ad7e6ce_at_993110h>...


>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.

Received on Sun Oct 19 1997 - 00:00:00 CDT