Skip to Main Content
Forums

Oracle Database Discussions

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!

Displaying time for date columns in SQL Developer

AntillesSep 18 2008 — edited Sep 18 2008
When I click a table to view it in SQL Developer (when it appears in a tab on the right hand side), if a column is date format, it only displays the date, and is always missing the time.

Is there a way to set it so that the time will display also?

I'm currently writing SELECT statements to get round this and display the time, using TO_CHAR(timestamp, 'DD-MON-YYYY HH:MI:SS') to get the date to display, which is annoying as I have a lot of tables I'm flicking between.
This post has been answered by 595286 on Sep 18 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2008
Added on Sep 18 2008
#general-database-discussions
2 comments
7,444 views