Re: Date format and Oracle

From: Kinna Patel <kinna_at_qmark.co.uk>
Date: Wed, 02 Jun 1999 15:00:22 GMT
Message-ID: <37554681.25644579@news.demon.co.uk>

The TO_DATE function would only work if I was using an Oracle database, therefore I have decided to us the standard syntax which would work on any databases.

My question now is how would I extract data from the database using filtering on dates ie give me all the records where Date1 > 1 Jun 1999

On Tue, 1 Jun 1999 15:18:46 +0200, "J. Wegener NOSPAM" <xjw_at_xdde.xdk> wrote:

>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 Wed Jun 02 1999 - 10:00:22 CDT