Mega Code Archive
The TIMESTAMP WITH TIME ZONE datatype stores the datetime
SQL>
SQL> DECLARE
2 v_datetime TIMESTAMP (3) WITH TIME ZONE := SYSTIMESTAMP;
3 BEGIN
4 DBMS_OUTPUT.PUT_LINE(v_datetime);
5 END;
6 /
03-JUN-07 08.51.27.046 PM -07:00
PL/SQL procedure successfully completed.
SQL>