Re: Date format and Oracle

Use either the standard syntax:
update R_List set Date1 = '01-JUN-99'

or apply a format mask:
update R_List set Date1 = to_date('6/1/99', 'MM/DD/YY')

See you SQL reference for details

Cheers
Johan

Kinna Patel skrev i meddelelsen <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.
Received on Tue Jun 01 1999 - 08:18:46 CDT