Home » SQL & PL/SQL » Client Tools » NLS_DATE FORMAT (Oracle 11.2.0.3 on Sparc 64bit)
NLS_DATE FORMAT [message #552999] Mon, 30 April 2012 14:45 Go to next message
naresh515
Messages: 11
Registered: September 2006
Junior Member
Hi All,

Can you please take a look at the below details and let me know what i'm missing or point me to the right direction?

We have explicitly set the nls_date_format to "DD-MON-FXYYYY" in the pfile

-- >On the database sever when i login as sys and do show parameter nls_date...i get the below -

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string DD-MON-FXYYYY
nls_date_language string

-- >Same steps when i perform on my machine with toad/sqlplus i'm getting different outputs.

NAME VALUE
nls_date_language AMERICAN
nls_date_format DD-MON-RR

Note: I haven't explicitly set any of the NLS parameters on my windows machine. Not sure from where the select on v$parameter where name like 'nls_date%' is getting different result set.

Thanks for your time on this..
Raghu Yella.

Re: NLS_DATE FORMAT [message #553000 is a reply to message #552999] Mon, 30 April 2012 14:48 Go to previous messageGo to next message
Littlefoot
Messages: 21367
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What are your own PC's regional settings set to?
Re: NLS_DATE FORMAT [message #553001 is a reply to message #552999] Mon, 30 April 2012 14:50 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Even if you don't explicitly set the NLS_DATE_FORMAT, Oracle (and I bet TOAD) does it at installation time depending on your regional OS settings as Littlefoot suggested.

Regards
Michel
Re: NLS_DATE FORMAT [message #553002 is a reply to message #553001] Mon, 30 April 2012 15:09 Go to previous messageGo to next message
naresh515
Messages: 11
Registered: September 2006
Junior Member
How to know if it has installed or has a setting on my machine?

I have checked for environmental settings under SYSTEM properties. But couldn't find any NLS settings there.

Thanks..
Re: NLS_DATE FORMAT [message #553005 is a reply to message #553002] Mon, 30 April 2012 15:32 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the registry, for Oracle, HKLM\Software\Oracle\...

Regards
Michel
Re: NLS_DATE FORMAT [message #553006 is a reply to message #553005] Mon, 30 April 2012 15:53 Go to previous messageGo to next message
naresh515
Messages: 11
Registered: September 2006
Junior Member
Thanks Michel.

I don't see anything related to NLS_DATE entry under the registry.

Came across below entry, removed it and restarted the machine and still see the same results.


NAME VALUE
nls_date_language AMERICAN
nls_date_format DD-MON-RR

We are expecting to see below entry..which we see it on the DB server -
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string DD-MON-FXYYYY
nls_date_language string
Re: NLS_DATE FORMAT [message #553008 is a reply to message #553006] Mon, 30 April 2012 16:49 Go to previous messageGo to next message
BlackSwan
Messages: 25858
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: NLS_DATE FORMAT [message #553010 is a reply to message #553008] Mon, 30 April 2012 18:34 Go to previous messageGo to next message
naresh515
Messages: 11
Registered: September 2006
Junior Member
Hi Blackswan,

Not sure the reason for your posting.. let me know if i missed any information?

I have clearly explained my question. Also i have done the research about this issue and as i couldn't find a solution i'm asking here.

Thanks,
Raghu.
Re: NLS_DATE FORMAT [message #553011 is a reply to message #553010] Mon, 30 April 2012 18:42 Go to previous messageGo to next message
BlackSwan
Messages: 25858
Registered: January 2009
Location: SoCal
Senior Member
> let me know if i missed any information?
what about doing as #7 directs?
Re: NLS_DATE FORMAT [message #553012 is a reply to message #553011] Mon, 30 April 2012 19:11 Go to previous messageGo to next message
naresh515
Messages: 11
Registered: September 2006
Junior Member
On my laptop opened a sqlplus session and performed the below statement.

sql>show parameter nls_date

NAME VALUE
nls_date_language AMERICAN
nls_date_format DD-MON-RR

We are expecting to see the below values on the client machine but it's not happening -
(Below are the values from the DB server)

sql>show parameter nls_date

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string DD-MON-FXYYYY
nls_date_language string
Re: NLS_DATE FORMAT [message #553017 is a reply to message #553006] Tue, 01 May 2012 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I don't see anything related to NLS_DATE entry under the registry.


When not explicitly set, it is derived from other parameters: NLS_LANG, NLS_LANGUAGE, NLS_TERRITORY.

Please read How to use [code] tags and make your code easier to read.

Regards
Michel
Re: NLS_DATE FORMAT [message #553057 is a reply to message #553017] Tue, 01 May 2012 08:16 Go to previous message
naresh515
Messages: 11
Registered: September 2006
Junior Member
Thanks Michel. I will follow the code rules.
Previous Topic: export and import suing sql developer
Next Topic: worksheet shortcut
Goto Forum:
  


Current Time: Sun Feb 25 04:29:53 CST 2018

Total time taken to generate the page: 0.04087 seconds