OraFAQ Forum: Server Administration » Change NLS_DATE

Home » RDBMS Server » Server Administration » Change NLS_DATE_FORMATE of Database......??

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

Change NLS_DATE_FORMATE of Database......?? [message #313620]

Sun, 13 April 2008 23:54

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi All,

I want to change my default date format for database. i.e. NLS_DATE_FORMAT

default is DD-MON-YYYY
I want DD/MM/YYYY

for a single session I can do this with
ALTER SESSION SET NLS_DATE_FORMAT= 'DD/MM/YYYY' ;

but I want to do it for all the sessions of database.
I searched my init.ora file there is no such parameter specified.

Do I need to add this parameter in this file.........??
OR is there any other initialization file in Oracle Database 10g..?

Thanks & Regards
Manoj

Report message to a moderator

Re: Change NLS_DATE_FORMATE of Database......?? [message #313640 is a reply to message #313620]

Mon, 14 April 2008 00:47

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Do I need to add this parameter in this file.........??

Yes... if you use it...

Quote:

OR is there any other initialization file in Oracle Database 10g..?

Yes, spfile.

Regards
Michel

Report message to a moderator

Re: Change NLS_DATE_FORMATE of Database......?? [message #313643 is a reply to message #313640]

Mon, 14 April 2008 00:51

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Which file to use for NLS_DATE_FORMAT

init.ora
or
spfile

????

After adding this parameter in file do I need to restart...??

Difference in both of these files....??

Report message to a moderator