Re: nls_date_format in initSID.ora

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 31 Aug 2001 22:00:43 +0800
Message-ID: <9mo5c4$gcf$1@violet.singnet.com.sg>

As you have noticed, doing an ALTER SESSION does set the NLS_DATE_FORMAT ---- thus you would see that client-side settings can and do override the server-side settings.

Where are you "seeing" the old format ? If you are using a client program (sqlplus) on Unix, check the Unix environment variables. NLS_DATE_FORMAT can be defined in the shell and it would then override the server-side settings. If you are using WinXXXXX clients, check the Registry entries for the oracle software installation for NLS_DATE_FORMAT.

--
Hemant K Chitale
http://hkchital.tripod.com
<simon.pospisil_at_fastsearch.com> wrote in message
news:3B8F993C.D927547B_at_fastsearch.com...


> Hello, I've tried changing the nls_date_format variable from:

> nls_date_format = DD-MON-YYYY

> to

> nls_date_format = YYYY-MM-DD

>

> Then I restart the database but it will only use the old format, the new

>

> format has not been recognised. I'm editing the initSID.ora file where

> SID is the sid of the database in question. Is that right? However, if

>  I alter the format within a session then it works fine.

>

> Any ideas?

>

> Cheers

>

> Simon.

>

>

Received on Fri Aug 31 2001 - 09:00:43 CDT