Today I Learned: collection of notes, tips and tricks and stuff I learn from day to day working with computers and technology as an open source contributor and product manager

View project on GitHub

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.