For date fields, by default SQL Developer will display only the date without time. To set it to display the time as well, do the following: Go to SQL Developer –> Tools >> Preferences. Select Database >> NLS Parameters from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field. Save and close
To share my ideas and knowledge with you : Java, Spring, ATG, Endeca, Solr, Cassandra, Kafka, Jboss, Eclipse, IntelliJ, Windows, MacOs, Tax tips

Comments
Post a Comment