Home » SQL & PL/SQL » Client Tools » NLS_DATE_FORMAT (Oracle 9i)
NLS_DATE_FORMAT [message #407201] Tue, 09 June 2009 01:27 Go to next message
manoj12
Messages: 175
Registered: March 2008
Location: India
Senior Member
Dear Sir

I have a server having Dateformat as dd/mm/yyyy.I wanted to change the date format to mm/dd/yyy.To change the date format I have written the script as

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



In SQL PLus the Date Format is showing as "MM/DD/YYYY".Whereas in PL/SQL Developer the Date format is showing as "DD/MM/YYYY".

what is the reason as to not showing the same date format in both the tools ?

Appreciate your help on the above?

Regards
Re: NLS_DATE_FORMAT [message #407206 is a reply to message #407201] Tue, 09 June 2009 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59065
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The statement works for the current session only.

Regards
Michel
Re: NLS_DATE_FORMAT [message #407208 is a reply to message #407206] Tue, 09 June 2009 02:00 Go to previous messageGo to next message
manoj12
Messages: 175
Registered: March 2008
Location: India
Senior Member
Dear Sir

Thanks for the reply but lets say.................
I HAVE WRITTEN THE QUERY AS


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


When I run the above mention scipt in SQL PLus the date format in iSQLPlus is getting changed to "MM/DD/YYYY" is shown as below.

select sysdate from dual
sysdate
-------------
06/09/2009



When I run the above mentioned script in PL/SQL Developer It is giving me Date format as "DD/MM/YYYY"

select sysdate from dual
sysdate
----------
09/06/2009



May I know what is the reason as to why not there is same date format in both the tools?

Appreciate your help on the above?

Regards
Re: NLS_DATE_FORMAT [message #407212 is a reply to message #407208] Tue, 09 June 2009 02:25 Go to previous message
Michel Cadot
Messages: 59065
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many reasons as we can't see what you did.
registry parameter
instance parameter
database parameter
and so on

The fact is that:
Quote:
The statement works for the current session only.


Regards
Michel

[Updated on: Tue, 09 June 2009 02:25]

Report message to a moderator

Previous Topic: spool format UTF8 in sqlplus9
Next Topic: Connect as SYSTEM
Goto Forum:
  


Current Time: Mon Sep 15 04:57:02 CDT 2014

Total time taken to generate the page: 0.06112 seconds