Re: y2k

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 9 May 1999 13:00:27 +0200
Message-ID: <926247498.3275.0.pluto.d4ee154e@news.demon.nl>

Hi Patrick,
Obviously your default date format is DD-MON-YY, which is not Y2K compliant. If you want anything else than the default format, you need to use an explicit format. I recommend using an explicit format ALWAYS. The second insert should have been
insert into to values(to_date('01-jan-2000','dd-mon-yyyy')

and this will work without problem.
If you want to use an Y2k compliant default format use dd-mon-rr.

Hth,

Sybrand Bakker, Oracle DBA

Patrick RIBAULT wrote in message <37355a4d_at_nuage.dreamtel.fr>...
>What is the correct syntax to insert a date with oracle 7.3
>
>insert into toto values ('01-jan-00') works but isn't fine with y2k
>insert into toto values ('01-jan-2000') does NOT work : Not a valid date
>
>What must I do ?
>
>--
>Patrick RIBAULT
>
>
>
Received on Sun May 09 1999 - 06:00:27 CDT