Re: 2000 AD - Oracle Date Format
From: Claude Tucker <70244.1244_at_CompuServe.COM>
Date: 1996/03/23
Message-ID: <4j1qcd$ose$1_at_mhafn.production.compuserve.com>#1/1
Date: 1996/03/23
Message-ID: <4j1qcd$ose$1_at_mhafn.production.compuserve.com>#1/1
Currently it will read as 1996. You can do an alter session on login to change Oracle's default date format to 'DD-MON-YYYY'. This way Oracle will use the century in its evaluation. I believe even if you use a TO_DATE('22-MAR-2096','DD-MON-YYYY') and select the value back using TO_CHAR(DATE_COLUMN, 'DD-MON-YYYY') you get the '22-MAR-1996' (you might want to verify this).
Hope this helps.
- Claude. 70244.1244_at_compuserve.com