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