Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

NLS_DATE_FORMAT not working

tinku981Apr 22 2013 — edited Apr 22 2013
Hello,

I ran NLS_DATE_FORMAT to modify date but it is not getting changed. Can you please advise the reason for same?

I am using Oracle 10.2 SQL Plus client and have run following commands on PL/SQL Developer Command Window.

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY MM DD';

Session altered
SQL> select sysdate from dual;

SYSDATE
-----------
4/22/2013 1

Thanks in advance,
Tinku
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2013
Added on Apr 22 2013
6 comments
830 views