1 Reply Latest reply: Jan 9, 2012 6:29 AM by Nicosa-Oracle RSS

    convert 'Thu Jan 05 13:07:00 IST 2012'  into timestamp(6)

    890271
      Hi all,

      how to convert this ('Thu Jan 05 13:07:00 IST 2012') date format into
      timestamp(6) ('mm/dd/yyyy hh12:ss:ff am') format.

      i have no idea about IST.

      thanks in advance