NLS_DATE_FORMAT can be specified with the Initialisation parameter,Environ variables ( at client side) or dynamic with the means of Alter session ( can`t set with alter system)..
you can override it in the TO_ functions, also

Sunjay Khangarot

-----Original Message-----
From: Chethan Anand N.
[mailto:oracledba-ezmlmshield-x68071615.[Email address protected]
Sent: Wednesday, August 04, 2004 11:10 AM
To: LazyDBA Discussion
Subject: RE: Oracle startup parameters -reg


try this
ALTER SYSTEM SET NLS_DATE_FORMAT = 'YYYYMMDD' scope=spfile;

ALTER SYSTEM SET NLS_DATE_FORMAT = 'YYYYMMDD' scope=both;(both pfile and
spfile)

Orasupport
-----Original Message-----
From: KANCHIS RAJESH
[mailto:oracledba-ezmlmshield-x41189162.[Email address protected]
Sent: Wednesday, August 04, 2004 11:04 AM
To: LazyDBA Discussion
Subject: Oracle startup parameters -reg


Hi gurus,

I would like to change the nls_date_format to 'YYYYMMDD' and the
existing server is using the values from 'SPFILE<Oracle_instance>.ORA'.
Is there any way I can modify this and moreover this is a session
variable.

This command works but this is active only for the session.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';

I want to change at the Oracle server level.

Thanks a lot in advance.

Regards
Rajesh






--------
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 e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************


--------
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





Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page