4 Replies Latest reply on Nov 28, 2011 7:19 PM by Rooney

    How to convert DATE to TIMESTAMP

    Rooney
      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 !