Use select into statement to assign systimestamp to timestamp variable : TIMESTAMP « PL SQL Data Types « Oracle PL/SQL Tutorial

SQL> SET SERVEROUTPUT ON
SQL>
SQL> DECLARE
  2
  3     v_date_time TIMESTAMP;
  4
  5  BEGIN
  6
  7     SELECT systimestamp
  8     INTO v_date_time
  9     FROM dual;
 10
 11     DBMS_OUTPUT.PUT_LINE(v_date_time);
 12
 13  EXCEPTION
 14     WHEN OTHERS
 15     THEN
 16        DBMS_OUTPUT.PUT_LINE(sqlerrm);
 17  END;
 18  /
03-JUN-07 08.51.26.031000 PM

PL/SQL procedure successfully completed.

SQL>

21.7.TIMESTAMP
	21.7.1.	Using TIMESTAMP
	21.7.2.	Declaring TIMESTAMP Datatype
	21.7.3.	TIMESTAMP literals
	21.7.4.	Using TIMESTAMP WITH TIME ZONE
	21.7.5.	'TIMESTAMP WITH TIME ZONE' in action
	21.7.6.	TIMESTAMP WITH LOCAL TIME ZONE
	21.7.7.	Use select into statement to assign systimestamp to timestamp variable
	21.7.8.	The TIMESTAMP datatype stores the date/time as follows
	21.7.9.	The TIMESTAMP WITH TIME ZONE datatype stores the date/time
	21.7.10.	The TIMESTAMP WITH LOCAL TIME ZONE datatype stores the date/time
	21.7.11.	Print the current date
	21.7.12.	Print the current date and timestamp
	21.7.13.	Two digits for fractional seconds
	21.7.14.	Nine digits for fractional seconds, 24-hour clock, 14:00 = 2:00 PM
	21.7.15.	No fractional seconds at all
	21.7.16.	No time zone, defaults to session time zone