Re: Date problems since 2000

From: Pete's <empete2000_at_yahoo.com>
Date: 9 Oct 2001 05:54:19 -0700
Message-ID: <6724a51f.0110090454.1156f627@posting.google.com>

Is it actually declared as DATE? I ran into this in my previous job and is documented on Oracle's Metalinks site. Instead of "YY" try using "RR" or "YYYY", this should resolve the date problem, actually the "RR" is correct one to use. Also, the init.ora parameter on the DB should be something similar to DD-MON-RR.

HTH,
Pete's

"Cefio" <support_at_cefio.fr> wrote in message news:<9pu5tu$t02$1_at_wanadoo.fr>...
> Hi
>
> I have encounterd a problem with my oracle version 7.3
> I have a table containing records with a date field ("DD/MM/YY")
> Since year 2000, all records with an year "99" are interpreted "2099"
> inspite of "1999"
> Can i result this problem ??
>
> Thanks
Received on Tue Oct 09 2001 - 07:54:19 CDT