sqldeveloper FAQ

How can I set a custom date time format in Oracle SQL Developer?

Courtesy: 

http://stackoverflow.com/questions/8134493/how-can-i-set-a-custom-date-time-format-in-oracle-sql-developer

You can change this in preferences:

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 DD-MON-RR HH24:MI:SS into the Date Format field.
4. Save and close the dialog, done!

Here is a screenshot: