Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Display the sessions current timetimezone AND the Operating systems timetimezone in PLSQL code block

SQL> -- SQL> SQL> SQL> begin   2  dbms_output.put_line('current_timestamp (session) '|| current_timestamp);   3  dbms_output.put_line('systimestamp (database) '||systimestamp);   4  end;   5  / current_timestamp (session) 16-JUN-08 04.36.26.959000000 PM -08:00 systimestamp (database) 16-JUN-08 05.36.26.959000000 PM -07:00 PL/SQL procedure successfully completed. SQL> SQL> --