PL SQL Data Types Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. PL SQL Data Types
  4. 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>