SQL & PL/SQL

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!

How to convert DATE to TIMESTAMP

Amer Ramamni-OracleNov 28 2011 — edited Nov 28 2011

Hi People,

I need to know how to convert a date attribute to a timestamp.
I am using Oracle 11g database, SQL Dev 3.

I am selecting a date field in my query and I want to convert this field to a timestamp.
How should I do this ?

select
         x.created_time,
from order_tbl x

Thanks for the help !

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2011

Added on Nov 28 2011

4 comments

311,116 views