TO_TIMESTAMP_TZ('2005-05-13 07:15:31.1234 PST','YYYY-MM-DD HH24:MI:SS.FF TZR') : TO_TIMESTAMP_TZ « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TO_TIMESTAMP_TZ

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


SQL> --TO_TIMESTAMP_TZ(x,[format]): convert x to a TIMESTAMP WITH TIMEZONE with an optional format for x.
SQL>
SQL> SELECT TO_TIMESTAMP_TZ('2005-05-13 07:15:31.1234 PST','YYYY-MM-DD HH24:MI:SS.FF TZR') FROM dual;

TO_TIMESTAMP_TZ('2005-05-1307:15:31.1234PST','YYYY-MM-DDHH24:MI:SS.FFTZR')
---------------------------------------------------------------------------
13-MAY-05 07.15.31.123400000 AM PST

SQL>
SQL>








Related examples in the same category

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