SELECT TO_TIMESTAMP_TZ('2005-05-13 07:15:31.1234 -7:00', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM') : TO_TIMESTAMP_TZ « Date Timestamp Functions « Oracle PL/SQL Tutorial






SQL> SELECT TO_TIMESTAMP_TZ('2005-05-13 07:15:31.1234 -7:00',
  2   'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
  3  FROM dual;

TO_TIMESTAMP_TZ('2005-05-1307:15:31.1234-7:00','YYYY-MM-DDHH24:MI:SS.FFTZH:
---------------------------------------------------------------------------
13-MAY-05 07.15.31.123400000 AM -07:00

SQL>
SQL>








13.23.TO_TIMESTAMP_TZ
13.23.1.TO_TIMESTAMP_TZ(x,[format]) convert x to a TIMESTAMP WITH TIMEZONE with an optional format for x.
13.23.2.SELECT TO_TIMESTAMP_TZ('2005-05-13 07:15:31.1234 -7:00', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
13.23.3.Examples of converting time zones to character strings
13.23.4.TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 -5:00','YYYY-MM-DD HH24:MI:SS.FF TZH:TZM')
13.23.5.TO_TIMESTAMP_TZ('2002-06-18 13:52:00.123456789 US/Eastern EDT','YYYY-MM-DD HH24:MI:SS.FF TZR TZD')