This discussion is archived
4 Replies Latest reply: Nov 28, 2011 11:17 AM by William Robertson RSS

How to convert DATE to TIMESTAMP

Rooney Newbie
Currently Being Moderated
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 !

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points