SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Hide the time if not present in date columns

Vincent BottemanMar 21 2014 — edited Mar 24 2014

Hi,

In the NLS preferences of SQL Developer 4.0.1 I changed the date format to DD/MM/YYYY HH24:MI:SS to see the time. But in our database, some date columns only contain dates without a time portion. In that case SQL Developer shows the value as 22/03/2014 00:00:00. How can I hide the time portion (00:00:00) in that specific case?

Regards,

Vincent Botteman

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2014

Added on Mar 21 2014

#sql-developer

3 comments

584 views