SQL>
SQL> DECLARE
2 a TIMESTAMP WITH TIME ZONE;
3 b VARCHAR2(40);
4 c TIMESTAMP WITH LOCAL TIME ZONE;
5 BEGIN
6 a := CAST ('24-Feb-2002 09.00.00.00 PM US/Eastern' AS TIMESTAMP WITH TIME ZONE);
7 b := CAST (a AS VARCHAR2);
8 c := CAST (a AS TIMESTAMP WITH LOCAL TIME ZONE);
9
10 DBMS_OUTPUT.PUT_LINE(a);
11 DBMS_OUTPUT.PUT_LINE(b);
12 DBMS_OUTPUT.PUT_LINE(c);
13 END;
14 /
PL/SQL procedure successfully completed.
SQL>