OraFAQ Forum: Server Administration » How to set nls_date

Home » RDBMS Server » Server Administration » How to set nls_date_format in oracle9i

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to set nls_date_format in oracle9i [message #59294]

Mon, 10 November 2003 10:11

jack
Messages: 123
Registered: September 2000

Senior Member

I want to set the parameter nls_date_format as
'mon-dd-yyyy hh:mi:ss'. I saw a solution that I can change the registery by adding an item under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE setting the string value with nls_date_format and setting value data with 'mon-dd-yyyy hh:mi:ss'.I tried and there was no reponse at all. Can someone tell me how to resolve my problem?

Thanks in advance!

Report message to a moderator

Re: How to set nls_date_format in oracle9i [message #59298 is a reply to message #59294]

Mon, 10 November 2003 18:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

You have to restart SQL*Plus for this, I guess...so the change is not immediate. You can also set the nls_date_Format by issuing an 'ALTER SESSION SET NLS_DATE_FORMAT=...' command.

If you want it to be persistent, include it in the GLOGIN.SQL file.

MHE

Report message to a moderator

Re: How to set nls_date_format in oracle9i [message #59310 is a reply to message #59298]

Tue, 11 November 2003 08:38

jack
Messages: 123
Registered: September 2000

Senior Member

First, I tried the way to change GLOGIN.SQL and failed. Could you please tell me how to set, espeically the format?
Second, your way just can be effective when I am using sql*plus. I want the sysdate will be changed whenever I am using rman, sqlplus or other tools

Thanks

Report message to a moderator

Re: How to set nls_date_format in oracle9i [message #59318 is a reply to message #59294]

Tue, 11 November 2003 11:51

Thiru
Messages: 1089
Registered: May 2002

Senior Member

did you add that as a String value ? and reboot. That should work. When you make it as a string value and just enter DD-MON-YY , it will automatically append " " and you shouldnt add any other quotes around the format string.

Report message to a moderator