Re: PLEASE HELP

From: Joost Ouwerkerk <joost.ouwerkerk_at_sickkids.on.ca>
Date: Thu, 03 Dec 1998 17:32:54 GMT
Message-ID: <3666ca99.7588191@resunix.sickkids.on.ca>

If you are using the DATE datatype in Oracle to store your dates, then they should be Y2K compliant. The default setting for output of the date in SQL*Plus is DD-Mon-YY but you can change this with the following command, or by setting this environment variable in init.ora:

ALTER SESSION SET NLS_DATE_FORMAT='DD-Mon-YYYY'

(you can choose any date format you like)

Joost Ouwerkerk
Toronto, Canada

On Thu, 03 Dec 1998 16:54:03 -0800, Steven <koh_cc_at_pacific.net.sg> wrote:

>hi,
>
> May l know how to make use any date function,
>
> in order to insert a date format of
>
> DD-MON-YYYY e.g 01-Mar-1998
>
> current date in datebase is 01-Mar-98
>
> (not 2000 compliance)
>
>Thank you
>
>--
>With regards
>Steven
>
>Steven Koh, Internet Software Engineer,
>
>
Received on Thu Dec 03 1998 - 11:32:54 CST