Skip to Main Content

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!

SQL Developer Ignoring NLS Preferences

981905Dec 27 2012 — edited Dec 27 2012
I'm having and issue with SQL Developer Version 3.2.20.09 where my settings in the NLS Date and Time preferences are not being used for the nls_session_parameters.

I've changed the default Date Format to RRRR-MM-DD HH24:MM:SS in the preferences, but when I start new sessions the format remains the default set of DD-MON-RR as verified when I run

SELECT *
FROM nls_session_parameters

If I run

alter session set NLS_DATE_FORMAT = 'RRRR-MM-DD HH24:MM:SS'

I can get the information to display the way I want it to, but it resets every time I start a new session.
This post has been answered by yoonas on Dec 27 2012
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 24 2013
Added on Dec 27 2012
2 comments
1,064 views