TIMESTAMP Value WITH LOCAL TIME ZONE
SQL> SQL> SQL> SET SERVEROUTPUT ON SQL> SQL> DECLARE 2 myDateTime_ltz TIMESTAMP WITH LOCAL TIME ZONE := TIMESTAMP '2004-06-05 22:14:01'; 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE(myDateTime_ltz); 5 END; 6 / 05-JUN-04 10.14.01.000000 PM PL/SQL procedure successfully completed. SQL> SQL>