Home » RDBMS Server » Server Administration » Change NLS_DATE_FORMATE of Database......??
Change NLS_DATE_FORMATE of Database......?? [message #313620] Sun, 13 April 2008 23:54 Go to next message
Manoj.Gupta.91
Messages: 217
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
Re: Change NLS_DATE_FORMATE of Database......?? [message #313640 is a reply to message #313620] Mon, 14 April 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: Change NLS_DATE_FORMATE of Database......?? [message #313643 is a reply to message #313640] Mon, 14 April 2008 00:51 Go to previous messageGo to next message
Manoj.Gupta.91
Messages: 217
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....??
Re: Change NLS_DATE_FORMATE of Database......?? [message #313644 is a reply to message #313620] Mon, 14 April 2008 00:53 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
yes,no,maybe
huh?
Re: Change NLS_DATE_FORMATE of Database......?? [message #313650 is a reply to message #313643] Mon, 14 April 2008 00:59 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Administrator's Guide

Regards
Michel
Previous Topic: Which query causing ORA-01555 error
Next Topic: Server Confirguration for 10gR2 Database (PROD)
Goto Forum:
  


Current Time: Sun Dec 11 08:29:20 CST 2016

Total time taken to generate the page: 0.07735 seconds