Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Difference between the DATE and TIMESTAMP datatypes

SQL> SQL> DECLARE   2    d DATE := SYSTIMESTAMP;   3    t TIMESTAMP(3) := SYSTIMESTAMP;   4  BEGIN   5    dbms_output.put_line('DATE      ['||d||']');   6  END;   7  / DATE      [26-OCT-09] PL/SQL procedure successfully completed. SQL>