Demonstrate the new ANSI Timestamp literal. Use 0-9 digits for fractional seconds
SQL> DECLARE 2 3 v1 DATE; 4 v2 TIMESTAMP; -- No time zone kept. 5 v3 TIMESTAMP WITH TIME ZONE; -- Preserves time zone entered. 6 v4 TIMESTAMP WITH LOCAL TIME ZONE; -- Converts session to DB time zone. 7 8 BEGIN 9 10 11 v2 := TIMESTAMP '2002-11-03 03:00:00.00'; 12 dbms_output.put_line(v2); 13 END; 14 / 03-NOV-02 03.00.00.000000 AM PL/SQL procedure successfully completed. SQL> SQL>