Oracle SQL Developer – Display Date and Time

Posted on by

By default Oracle SQL Developer displays only a date component on date time field. You can change this behaviour in preferences.

Go to Tools -> Preferences -> Database -> NLS and change Date Format value to DD-MON-RR HH24:MI:SS (for 24 hour time display) or DD-MON-RR HH:MI:SS (for 12 hour time display).

SQLDev

One thought on “Oracle SQL Developer – Display Date and Time”

Leave a comment