Skip to Main Content
Forums

SQL Developer

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!

How can I tell SQL Developer to always display datetime values in full?

ThePlutonianMay 7 2010 — edited May 10 2010
This is really annoying. SQL Developer only displays the date part of datetime variables. Okay, if I preface each query with "ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS';", it will force the datetime value to display, but that it a nuissance!

How can we make SQL Developer ALWAYS display the full datetime value?
This post has been answered by rsrini on May 9 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2010
Added on May 7 2010
#sql-developer
4 comments
5,330 views