Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. 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  /
26-OCT-09 10.40.52.639 AM -08:00
PL/SQL procedure successfully completed.
SQL>