Re: Date format and Oracle

From: Fred Ruffet <fruffet_at_kaptech.com>
Date: Tue, 1 Jun 1999 15:10:27 +0200
Message-ID: <7j0m4u$17b$1@gatekeeper.ornano.kapt.com>

Kinna Patel a écrit dans le message <3753ca7c.12325469_at_news.demon.co.uk>...
>Does anyone know what the SQL is to insert a field of date format into
>an Oracle database.
>
>At the moment I am using
>
>Update R_List set Date1 = '6/1/99'
>
>which is suppose to insert a date of 1 June 99 into my table.
>
>However, I get an error 'not a valid month' when my database is
>Oracle. However, this SQL works when the database is say SQL.
>
>I need some SQL whcih will work whatever database I am using.
>
>I hope some in this newsgroup will be able to help.

All I know is that
update R_List set Date1=To_date('06/01/1999','DD/MM/YYYY') would work fine. I hope this will help.

Regards,

Fred Received on Tue Jun 01 1999 - 08:10:27 CDT