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>