It is really really easy to change the default NLS_DATE_FORMAT setting but to be honest, you should set it at a session level IMHO. We basically just need to run “ALTER SYSTEM SET NLS_DATE_FORMAT=’YYYY-MM-DD’ SCOPE=SPFILE” as a user with sysdba privileges. If you started the Oracle instance without a spfile (it should be located at [...]
How to change the default NLS_DATE_FORMAT (Date format) in Oracle 10g/11g
by Jason L Froebe on May 6, 2010, 3 comments
