Re: Date problems

Bonjour,

It took you a while to realize that :-)

I suppose your problem is that dates are input as DD/MM/YY and stored with current century. Hence the 99 is stored as 2099.
You should and should have done that a long time ago use YYYY and have your users enter 4-digit dates to make sure there is no misunderstanding.
Alternatively you can use the format DD/MM/RR instead. I believe Oracle set the window at 49. So 00-49 becomes 20xx and 50-99 becomes 19xx.

Hope this helps,
Bonne chance,

--
Today, Tomorrow, Together
The DOC
(The Dutch Oracle Company)
www.thedoc.nl
Xavier Neys



PS: you should sign you messages. I usually do not answer to anonymous letters,
but [entre francophones] I can make an exeption.


"Cefio" <support_at_cefio.fr> wrote in message news:9q0rkv$da7$1_at_wanadoo.fr...


> Hi

>

> I am working under Oracle version 7.3 and i have a table containing a date

> field.

> Since year 2000, all records with an year 99 are interpreted 2099 inspite of

> 1999.

> Can i resolve this problem ??

> If yes where in Oracle must i do the modification ??

>

> Thanks.

>

>

>

>