Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

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>