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!

Configuration Setting for "alter session set nls_date_format"?

nreedJan 28 2009 — edited Feb 5 2009
I use: 
alter session set nls_date_format = 'MM/DD/YYYY HH24:MI:SS';
to format a column of type DATE to display the time stamp also. This worked fine, but I'm using SQL Developer 1.5.1 and have to do it each time I log in.

Is there a place I can set this to always use this setting each time I run the client?

Thanks,
Neal
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2009
Added on Jan 28 2009
#sql-developer
12 comments
4,237 views