Oracle SQL Developer: Show Time with Date

By default, SQL Developer does not display the Time with the date for date columns when running a select statement.

You can change this in the Tools / Preferences dialog of SQL developer:

  1. Select Database / NLS Parameters in the tree view on the left.

  2. Then put dd/mm/yyyy hh24:mi:ss into the Date Format field.

  3. Press OK to close the dialog.

Enjoy!

Comments are closed