Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

TIMESTAMP literal supports Time Zone (as offset from UTC) Default is SESSION Timezone

SQL> SQL> DECLARE   2   3      v1  DATE;   4      v2  TIMESTAMP;                    5      v3  TIMESTAMP WITH TIME ZONE;     6      v4  TIMESTAMP WITH LOCAL TIME ZONE;     7   8  BEGIN   9  10    11      v3 := TIMESTAMP '2002-11-03 03:00:00 -07:00';  12      dbms_output.put_line(v3);  13  14  END;  15  / 03-NOV-02 03.00.00.000000 AM -07:00 PL/SQL procedure successfully completed. SQL>