alter system set NLS_DATE_FORMAT = 'MM/DD/YYYY' scope=spfile;
and after executing the command restart the DB.

-----Original Message-----
From: Rupesh Shah
[mailto:oracledba-ezmlmshield-x71416616.[Email address protected]
Sent: 30 November 2004 18:30
To: LazyDBA Discussion
Subject: NLS_DATE_FORMAT

How to change nls date format for the database.?



Below command does not work

alter system set NLS_DATE_FORMAT = 'MM/DD/YYYY';



Regards,

rupesh



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee/recipient. Access to this message by any one else is unauthorized. If you are not the intended addressee/recipient any disclosure, copying or distribution of the message, or any action or omission taken by you by relying on it is prohibited and may be unlawful. Please notify the addressor/sender immediately if you have received this message in error. The organization is not responsible for any damage caused by a virus or an alteration of the e-mail by a third party or otherwise. The contents of this message may not necessarily represent the views or the policies of the organization.


Oracle LazyDBA home page