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>