Default display format for date field in Oracle SQL Developer

For date fields, by default SQL Developer will display data in date only without the time. To set it to display the time as well, do the following:

1. From SQL Developer, open menu Tools >> Preferences.
2. From the Preferences dialog, select Database >> NLS Parameters from the left panel.
3. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field.
4. Save and close the dialog, done!

4 Comments to “Default display format for date field in Oracle SQL Developer”

  1. By Icaro, March 18, 2009 @ 12:57 am

    thank you!
    Very usefull

  2. By trenord, April 23, 2009 @ 6:56 am

    This is excellent!

  3. By uttam, April 23, 2009 @ 10:54 am

    thanks a lot!

    very much helpful!!!!!

  4. By zenx, April 26, 2009 @ 12:49 am

    You are welcome :) I learnt this trick from a colleague of mine. Glad to see it helps someone.