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 in PLSQL Developer differ from sqlplus

DKhatiyanAug 31 2015 — edited Sep 1 2015

Hi,

When setting the nls_date_format from sqlplus at session level, results are as expected.Capture.JPG

whereas when setting the nls_date_format at seesion level in PL/SQl developer, output has the same format in both the case.

Capture1.JPG

kindly help on same...

This post has been answered by Marwim on Sep 1 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2015
Added on Aug 31 2015
6 comments
1,517 views