How to change NLS Setting

Sometimes, Oracle SQL Developer display the date format as ‘DD-MM-YY’ although I changed the format on the preference.



To change it manually on the session run following query.

ALTER SESSION SET NLS_DATE_FORMAT = ‘YYYY-MM-DD hh24:mi:ss’;