Display the sessions current time/timezone AND the Operating systems time/timezone in PL/SQL code block : SYSTIMESTAMP « Date Timezone « Oracle PL / SQL






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

1.Get the SYSTIMESTAMP
2.Use systimestamp in insert statement
3.Using systimestamp to do benchmark