Tuesday, September 10, 2013

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.