Re: How do I change nls_date

From: David Pattinson <dpattinson_at_enternet.com.au>
Date: Tue, 04 Jan 2000 11:53:03 +1100
Message-ID: <3871446F.2868A85E@enternet.com.au>

I believe that nls_lang also affects the date format, you may have to make sure that you are setting nls_date_format after you set nls_lang. I'm assuming that you want to change the default date format for the server, otherwise an "alter session" command will do the trick.

David.

Peter Bryant wrote:

> How do I change nls_date_format on Oracle 8 for NT. I've set the registry
> key:
>
> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_DATE_FORMAT
>
> and editted the init.ora file.
>
> Anyone have any further ideas? Basically, I want it to recognise
> 'YYYY-MM-DD' with an optional HH24:MM:SS.
>
> TIA
>
> - Peter Bryant
Received on Mon Jan 03 2000 - 18:53:03 CST

Re: How do I change nls_date_format?