Retrieve the timestamp into a variable
SQL> SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE 2 myDateTime TIMESTAMP; 3 BEGIN 4 SELECT systimestamp INTO myDateTime FROM dual; 5 DBMS_OUTPUT.PUT_LINE(myDateTime); 6 EXCEPTION 7 WHEN OTHERS 8 THEN 9 DBMS_OUTPUT.PUT_LINE(sqlerrm); 10 END; 11 / 26-OCT-09 10.40.28.429000 AM PL/SQL procedure successfully completed. SQL> SQL>