| NLS_DATE_FORMAT [message #407201] |
Tue, 09 June 2009 01:27  |
manoj12
Messages: 210
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 #407208 is a reply to message #407206] |
Tue, 09 June 2009 02:00  |
manoj12
Messages: 210
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 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
