SQL>
SQL> DECLARE
2
3 v1 DATE;
4 v2 TIMESTAMP;
5 v3 TIMESTAMP WITH TIME ZONE;
6 v4 TIMESTAMP WITH LOCAL TIME ZONE;
7
8 BEGIN
9
10
11 v4 := TIMESTAMP '2002-11-03 03:00:00 -07:00';
12 dbms_output.put_line(v4);
13
14 END;
15 /
03-NOV-02 02.00.00.000000 AM
PL/SQL procedure successfully completed.
SQL>
SQL>