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:
-
Select Database / NLS Parameters in the tree view on the left.
-
Then put dd/mm/yyyy hh24:mi:ss
into the Date Format field.
-
Press OK to close the dialog.
Enjoy!