Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

SELECT TO_TIMESTAMP_TZ(2005-05-13 07

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>