How to change Oracle SQL Developer default date format
By default Oracle SQL developer does not show time stamp with date field. You can change it in two ways:
1. Run the following script
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
This script needs to be execute for a new session.
2. Another option can be:
a. From tools menu select...
[read more]
Submit a review:
Login required.