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 v3 := TIMESTAMP '2002-11-03 03:00:00 -07:00';
12 dbms_output.put_line(v3);
13
14 END;
15 /
03-NOV-02 03.00.00.000000 AM -07:00
PL/SQL procedure successfully completed.
SQL>