Skip to Main Content
Forums

Oracle Database Discussions

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 on Windows

837079Mar 10 2011 — edited Mar 12 2011
11g installed on Windows XP - cannot get NLS_DATE_FORMAT to work!

Have tried setting NLS_DATE_FORMAT="MM/DD/RR" in the init.ora file.

Have tried setting same value in the registry key HKLM/SOFTWARE/ORACLE/KEY_OraDb11g_home1

Database stopped and restarted after each change.

Nothing works!

select sysdate from dual; always returns a date in the form 10-MAR-11 ---------- NOT what I need:(

We need this set at the system level - not the session level, so.........

Clues??
This post has been answered by JustinCave on Mar 10 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2011
Added on Mar 10 2011
#11g, #database, #date, #general-database-discussions
25 comments
15,899 views