Monday, February 10, 2014

How to set Custom DateTime Format in SQL Developer

In order to display the custom Date Format in SQL Devloper, configure the NLS parameters as follows:

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

By default Oracle SQL Developer displays the Date Format as 10-FEB-14

No comments:

Post a Comment