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