SQL Developer: Set default date format to date and time

SQL Developer default display date field data without time:

We can set this default date format to date and time:

• Open SQL Developer, Open Menu Tools => Preferences
• From the Preferences dialog, Select option Database=> Click NLS
• NLS paremeters will display right side
• Update the "Date Format" parameter value to "DD-MON-RR HH24:MI:SS"
• Click "Ok" button to save and close the preference dialog

You have done, Now run the select statement and see the date filed values.