3 Replies Latest reply: Apr 18, 2011 4:56 PM by 806311 RSS

    timestamp_iso

    630791
      In DB2 there is a function named timestamp_iso()

      Like if I make a SQL

      select current time, timestamp_iso(current time) from dual

      The output will be

      1 2
      ---------- --------------------
      9:13:31 PM 4/11/2008 9:13:31 PM

      1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 0/ms]

      which means for column one is '9:13:31 PM'
      for culumn two is '4/11/2008 9:13:31 PM'

      My question is, do we have corresponding function in Oracle for 'timestamp_iso'?

      Thnaks,
      J.

      Message was edited by:
      user627788