The TIMESTAMP WITH LOCAL TIME ZONE datatype stores the date/time
SQL>
SQL> DECLARE
2 v_datetime TIMESTAMP (0) WITH LOCAL TIME ZONE := SYSTIMESTAMP;
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE(v_datetime);
5 END;
6 /
26-OCT-09 10.40.53 AM
PL/SQL procedure successfully completed.
SQL>