| unable to set NLS_DATE_FORMAT [message #71755] |
Tue, 07 January 2003 02:46  |
Niranjan
Messages: 34
Registered: June 2001
|
Member |
|
|
hai all,
I'm facing a problem in setting the parameter NLS_DATE_FORMAT. Though I set this parameter in the Init.ora and try to retrive the date, its showing in other format than what I had set.
I set NLS_DATE_FORMAT = "DD-MM-YYYY HH24:MI:SS"
but I'm getting the date in the format of dd-mm-yy.
I checked out for other parameters that are set by default in v$parameter and I found only nls_language and nls_territory are set to American.
So,let me know what the mistake am doing and help me to get the date in format which I set.
thanx in advance.
|
|
|
|
| Re: unable to set NLS_DATE_FORMAT [message #71757 is a reply to message #71755] |
Tue, 07 January 2003 04:29  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
after setting nls_date,
did you toggle the database?
only if you restart the database with the concerned
init< sid >.ora , the settings will come to effect.
you can also set the same in your login profile (unix).
export NLS_DATE_FORMAT=< YOURFORMAT >
OR by session (inside sql).
alter session set nls_date_format=' yourformat ';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
