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.
- From Oracle SQL Developer’s menu go to: Tools > Preferences.
- From the Preferences dialog, select Database > NLS from the left panel.
- From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field.
- Save and close the dialog, done!