Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Default Date formatting with NLS_DATE_FORMAT
Hi all.
We want to change our database's default date formatting. The current format is "DD-MON-YY", which I guess results from the value of NLS_TERRITORY which is "AMERICA".
I want to change the date format to "YYYY/MM/DD".
I've tried to change the value of NLS_DATE_FORMAT parameter. When I execute :
alter session set NLS_DATE_FORMAT = "YYYY/MM/DD"
the format changes for the current session.
However, I want to make this format the default one for all sessions. The manual suggests to make an entry in the init.ora file for the NLS_DATE_FORMAT parameter. I included the following entry in our database's init.ora file :
nls_date_format="YYYY/MM/DD"
The database was then shutted down and restarted. However, the default date format didn't change and remained "DD-MON-YY". Any explanations ?
I would like to thank you in advance.
Ilias
Received on Fri Feb 19 1999 - 06:00:16 CST