Re: nls_date

From: Michael Forester <michael.forester_at_ibm.net>
Date: 1999/02/16
Message-ID: <36c9373d.1057300@news2.ibm.net>#1/1

I created the following REG file to insert the registry entry into all clients in a login script. However, once the file is run and the PC is rebooted the entry does not appear in the registry. I do get a message saying that the registry information was properly merged into the registry. What's wrong?

REGEDIT4 ; Double click on this file from Explorer to automatically ; insert these values into the registry.

;    Michael S. Forester
;    Wednesday, February 10, 1999
;    Set registry value for four digit years in Oracle clients

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]
"NLS_DATE_FORMAT"=REG_EXPAND_SZ:"DD-MON-YYYY"

Michael S. Forester
IT Legal Systems
PricewaterhouseCoopers
michael.forester_at_us.pwcglobal.com
michael.forester_at_ibm.net

On Mon, 15 Feb 1999 11:29:54 -0500, Xueyou Hu <xhu_at_cceb.upenn.edu> wrote:

>my problem:
>
>I create a new database, the default nls_date_format is 'DD-MON-YY', but our
>project span from 1890-1999, I need to change the nls_date_fromat to
>'MON-DD-YYYY', I try "alter session set nls_date_format = 'MON-DD-YYYY'", it
>is ok, the format work in this session, then I go to initial parameter file
>to change the the nls_date_fromat to 'MON-DD-YYYY', shutdown and startup the
>database, but it doesn't work. I don't know why, anybody can tell me how to
>make that work.
>
>Thanks in advance.
>
>Stanley Hu
Received on Tue Feb 16 1999 - 00:00:00 CST

Re: nls_date_format