Print the current date and timestamp : TIMESTAMP « PL SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. PL SQL Data Types
  3. TIMESTAMP
SQL>
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
  2     v_sysdate DATE := SYSDATE;
  3     v_systimestamp TIMESTAMP := SYSTIMESTAMP;
  4     v_date DATE;
  5     v_number NUMBER(10);
  6  BEGIN
  7
  8     -- Print the current date and timestamp
  9     DBMS_OUTPUT.PUT_LINE(v_systimestamp);
 10
 11  END;
 12  /
03-JUN-07 09.03.58.593000 PM

PL/SQL procedure successfully completed.

SQL>
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