Thursday, May 29, 2014

Oracle SQL Developer - Display Time for any Date fields in Oracle DB Tables



By default, Oracle SQLDeveloper displays date fields with day, month and year information.


 If we need time as well for all the date fields below should be done.



n Oracle SQLDeveloper Go to: Tools >> Preferences >> Database > NLS Parameters and update your Date Format field to DD-MON-RR HH:MI:SS value