Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

TO_TIMESTAMP_TZ(2005-05-13 07

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>