Display the sessions current time/timezone AND the Operating systems time/timezone in PL/SQL 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> --
Related examples in the same category