The TIMESTAMP WITH LOCAL TIME ZONE datatype stores the datetime
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>