Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

TIMESTAMP(3)

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