Re: Date problems since 2000

From: andrew_webby at hotmail <andrew_webby_at_hotmail.com>
Date: 9 Oct 2001 03:54:30 -0700
Message-ID: <f45d9b0.0110090254.3d517a08@posting.google.com>

"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

Try DD/MM/YYYY... but it's likely that you insterted those records in the format of DD/MM/YY, so they will actually be 2099. You possibly need to correct your data.

And use a current version of oracle ... ;-) Received on Tue Oct 09 2001 - 05:54:30 CDT