Get the SYSTIMESTAMP : SYSTIMESTAMP « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. SYSTIMESTAMP

Get the SYSTIMESTAMP

 

SQL> --SYSTIMESTAMP()
SQL>
SQL> SELECT SYSTIMESTAMP FROM dual;

SYSTIMESTAMP
---------------------------------------------------------------------------
16-SEP-06 05.35.06.531000 PM -07:00

SQL>








Related examples in the same category

1.Display the sessions current time/timezone AND the Operating systems time/timezone in PL/SQL code block
2.Use systimestamp in insert statement
3.Using systimestamp to do benchmark