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!

Oracle SQL Developer datetime format

656582Aug 28 2008 — edited Aug 28 2008

Hi

I am using Oracle SQL Developer 1.5.1. When I query from a table with a DATE type column, the result data for that column shows only date but not time, as below.

ID          TIME_STAMP
.....        ....................
100         29-AUG-08

How can I get it display full date and time like 29-AUG-08 08:46:22.0

Thanks

Edited by: user10182401 on Aug 28, 2008 8:19 PM

Edited by: user10182401 on Aug 28, 2008 8:21 PM

Edited by: user10182401 on Aug 28, 2008 8:23 PM

This post has been answered by JustinCave on Aug 28 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2008

Added on Aug 28 2008

#general-database-discussions

1 comment

4,788 views