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

Home -> Community -> Usenet -> c.d.o.tools -> Re: NLS_DATE_FORMAT

Re: NLS_DATE_FORMAT

From: Tom Zamani <tomz_at_redflex.com.au>
Date: 1999/12/13
Message-ID: <831nk1$739$1@perki.connect.com.au>#1/1

What you have done would have worked if DB was on Unix, for nt you need to edit the registry. put the date format in there and it should work. Ezzedin Habib <ehabib_at_wantree.com.au> wrote in message news:830s09$2jl$1_at_centipede.wantree.com.au...
> I am running Oracle Workgroup Server version 7.3.4.1.1 on a Windows NT 4.0
> server with service pack 5.
>
> In an attempt to set the date format to DD-MON-YYYY, I added the
 following:
> NLS_DATE_FORMAT="DD-MON-YYYY" to the init.ora file restarted the database
> but still it would accept and display dates in DD-MON-YY format. Next, I
> removed the "My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\NLS_LANG
> registry entry and the database would display dates in DD-MON-YYYY format
> but would still accept DD-MON-YY in an insert or update and store the date
> value as DD-MON-00YY.
>
> Has anybody encountered this problem and can anybody please tell how to
> solve it. In all my UNIX installation all I had to do is the change in the
> init.ora file and everything goes well. Thank you.
>
> Regards,
> Ezzedin Habib
>
>
Received on Mon Dec 13 1999 - 00:00:00 CST

Original text of this message

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