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

• StackOverflow
• Oracle Help Center
• Wikipedia: ISO 8601