OraFAQ Forum: Client Tools » NLS

Home » Other » Client Tools » NLS_DATE FORMAT (Oracle 11.2.0.3 on Sparc 64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

NLS_DATE FORMAT [message #552999]

Mon, 30 April 2012 14:45

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.

Report message to a moderator

Re: NLS_DATE FORMAT [message #553000 is a reply to message #552999]

Mon, 30 April 2012 14:48

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What are your own PC's regional settings set to?

Report message to a moderator

Re: NLS_DATE FORMAT [message #553001 is a reply to message #552999]

Mon, 30 April 2012 14:50

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: NLS_DATE FORMAT [message #553002 is a reply to message #553001]

Mon, 30 April 2012 15:09

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

Report message to a moderator

Re: NLS_DATE FORMAT [message #553005 is a reply to message #553002]

Mon, 30 April 2012 15:32

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In the registry, for Oracle, HKLM\Software\Oracle\...

Regards
Michel

Report message to a moderator

Re: NLS_DATE FORMAT [message #553006 is a reply to message #553005]

Mon, 30 April 2012 15:53

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

Report message to a moderator

Re: NLS_DATE FORMAT [message #553008 is a reply to message #553006]

Mon, 30 April 2012 16:49

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: NLS_DATE FORMAT [message #553010 is a reply to message #553008]

Mon, 30 April 2012 18:34

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.

Report message to a moderator

Re: NLS_DATE FORMAT [message #553011 is a reply to message #553010]

Mon, 30 April 2012 18:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> let me know if i missed any information?
what about doing as #7 directs?

Report message to a moderator

Re: NLS_DATE FORMAT [message #553012 is a reply to message #553011]

Mon, 30 April 2012 19:11

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

Report message to a moderator

Re: NLS_DATE FORMAT [message #553017 is a reply to message #553006]

Tue, 01 May 2012 00:34

Michel Cadot
Messages: 68774
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: NLS_DATE FORMAT [message #553057 is a reply to message #553017]

Tue, 01 May 2012 08:16

naresh515
Messages: 11
Registered: September 2006

Junior Member

Thanks Michel. I will follow the code rules.

Report message to a moderator

Previous Topic:	export and import suing sql developer
Next Topic:	worksheet shortcut

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 25 05:25:09 CST 2026