Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

The TIMESTAMP datatype stores the datetime as follows

SQL> SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE   2     v_datetime TIMESTAMP := SYSTIMESTAMP;   3  BEGIN   4     DBMS_OUTPUT.PUT_LINE(v_datetime);   5  END;   6  / 03-JUN-07 08.51.26.828000 PM PL/SQL procedure successfully completed. SQL>