Re: Date format and Oracle

From: Eckehard Reinhold <ereinhol_at_cm-muc.de>
Date: Mon, 07 Jun 1999 15:51:14 +0200
Message-ID: <375BCE52.1139F7B5@cm-muc.de>

Maybe you can use the ALTER SESSION command, to set the NLS_DATE_FORMAT to your properly used format. Something like this: EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YY'; Then in your Whole session the date format is this that you have set.

Kinna Patel wrote:

> 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 Mon Jun 07 1999 - 08:51:14 CDT