Re: unable to change nl_date_format(NT oracle)

Hi Ted,

Client programs refer to the registry. If there is no setting for NLS_DATE_FORMAT in the registry, the default DD-MON-YY will be used. You need to add the string value NLS_DATE_FORMAT = 'DD-MON-YYYY' to hklm\software\oracle, and it should work.

Hth,

Sybrand Bakker, Oracle DBA

tedchyn_at_yahoo.com wrote in message <7emji6$pvr$1_at_nnrp1.dejanews.com>...
>Sir,
>
>After add nls_date_format=DD-MON-YYYY to init.ora file and restart oracle,
>the nls_database_parameters still show DD-MON-YY format( alert.log indicate
>the right nls_date_format).
>
>However, I'm able to use alter session command to change nls_date_format to
>DD-MON-YYYY(but this only last for a session).
>
>nls_lang is the right format. I'm using oracle 8.0.5(NT).
>
>Thanks in advance
>
>Ted Chyn (please respond to tedchyn_at_yahoo.com)
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sat Apr 10 1999 - 00:12:19 CDT