Skip to content

Latest commit

 

History

History
18 lines (12 loc) · 944 Bytes

setting_dateformat.md

File metadata and controls

18 lines (12 loc) · 944 Bytes
Raw

Setting the date format

The reason why I wrote this til is because it took me some time to hunt down and I might forget how to do it.

  1. From Oracle SQL Developer's menu go to: "Tools" > "Preferences"
  2. From the "Preferences" dialog, select: "Database" > "NLS" from the left panel
  3. From the list of NLS parameters, enter RRRR-MM-DD HH24:MI:SS into the "Date Format" field.
  4. Save and close the dialog - done!

My suggestion is using ISO 8601 format, but you can change to you preferences, do visit this page at the Oracle Help Center for more details.

References