Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

The TIMESTAMP WITH TIME ZONE datatype stores the datetime

SQL> SQL> DECLARE   2     v_datetime TIMESTAMP (3) WITH TIME ZONE := SYSTIMESTAMP;   3  BEGIN   4     DBMS_OUTPUT.PUT_LINE(v_datetime);   5  END;   6  / 26-OCT-09 10.40.52.639 AM -08:00 PL/SQL procedure successfully completed. SQL>