How to change nls_session_parameters?

[Andrew Weinstein]

This is for Oracle 8.0.4 running on NT:

I need to change the default date from "DD-MON-YY" to "YYYY-MM-DD". When I
try the following update query:

UPDATE NLS_SESSION_PARAMETERS SET VALUE = 'YYYY-MM-DD' WHERE PARAMETER =
'NLS_DATE_FORMAT'

I receive the following exception:

ERROR at line 1:
ORA-02030: can only select from fixed tables/views

I looked through the documentation and it goes through this long involved
process with the NLS Configuration utility.
"The NLS Configuration Utility is invoked from the command line with the
following syntax:
LXBCNF [ORANLS=pathname] [userbootdir=pathname]
[DESTDIR=pathname] [HELP=[yes |no]]"

When I do a dir on lxbcnf*.* I don't even get a hit on this file.

Can anyone offer some help on how to change the default date format?

Thanks in advance,

Andrew Weinstein
Dallas, TX

[Jérôme Texier]

Try, if it's just for a session :

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';

Andrew Weinstein <and...@anet-dfw.com> a écrit dans le message :
92341323...@news.remarQ.com...

[Andrew Weinstein]

This works as promised for a session, but anyone with advice for how to
accomplish for all users & all sessions? The format "04-APR-99' does not
appear to be the easiest way to work with dates as well as Y2K compliant..
I would assume most servers would be defaulted to something like:
'1999-04-06 16:14:00'

Anyone else agree?

Jérôme Texier wrote in message <7edcon$dbr$1...@jaydee.iway.fr>...

[vincent]

you need to set this parameter in your initSID.ora parameter file
NLS_DATE_FORMAT = 'YYYY-MM-DD'

[li...@novasprint.com]

Hi there,

I've the some problem as well on NLS_DATE_FORMAT. I did change on
initSID.ora but
it was not changed when I connect to DB.

Then I refer to Data Dictionary,

NLS_INSTANCE_PARAMETER shows NLS_DATE_FORMAT = 'DD-MM-YYYY'

but

NLS_SESSION_PARAMETER shows NLS_DATE_FORMAT = 'DD-Mon-YY' (default
value)

Can anyone help me on this. Thank You

Wean

vincent wrote:

--
************************* HAVE A NICE DAY ! **************************

Lim Huay Wean
Novasprint Systems Sdn Bhd
22.04 Menara Shahzan Insas
30 Jalan Sultan Ismail
50250 Kuala Lumpur
MALAYSIA
Tel: (603) 248 2787
Fax: (603) 248 2821

E-mail: li...@novasprint.com

********************* Don't Worry! Be Happy! ************************

[li...@novasprint.com]

[Mohamad SALEH]

Just one precision : NLS parameters in the client machine prime on the
those of the server.
So, you have to do it on all your client machines if you want it to be
universal.