Define and set timestamp value
SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE 2 myDateTime TIMESTAMP := TIMESTAMP '2004-06-05 22:14:01'; 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE(myDateTime); 5 END; 6 / 05-JUN-04 10.14.01.000000 PM PL/SQL procedure successfully completed. SQL> SQL>