Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Date format and Oracle

Re: Date format and Oracle

From: Kenny Gump <kgump_at_mylanlabs.com>
Date: Tue, 1 Jun 1999 13:01:36 -0400
Message-ID: <375411ec.0@news.mountain.net>


Check your NLS_DATE_FORMAT parameter. It is probably the Oracle default DD-MON-YY. Regardless the following will work:

update r_list
set date1 = to_date('06/01/99', 'MM/DD/YY');

Kenny Gump
Kinna Patel wrote in 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.
Received on Tue Jun 01 1999 - 12:01:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US