TO_TIMESTAMP_TZ(x): Converts the string x to a TIMESTAMP WITH TIME ZONE : TO_TIMESTAMP_TZ « Date Timezone « Oracle PL / SQL






TO_TIMESTAMP_TZ(x): Converts the string x to a TIMESTAMP WITH TIME ZONE



SQL> --TO_TIMESTAMP_TZ(x): Converts the string x to a TIMESTAMP WITH TIME ZONE.
SQL>
SQL>
SQL> SELECT TO_TIMESTAMP_TZ('1999-12-01 11:00:00 -8:00',
  2     'YYYY-MM-DD HH:MI:SS TZH:TZM') FROM DUAL;

TO_TIMESTAMP_TZ('1999-12-0111:00:00-8:00','YYYY-MM-DDHH:MI:SSTZH:TZM')
---------------------------------------------------------------------------
01-DEC-99 11.00.00.000000000 AM -08:00

SQL>
SQL>
           
       








Related examples in the same category

1.TO_TIMESTAMP_TZ('2005-05-13 07:15:31.1234 PST','YYYY-MM-DD HH24:MI:SS.FF TZR')