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>