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
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