select current_timestamp from dual to see the session time : CURRENT_TIMESTAMP « Date Timezone « Oracle PL / SQL






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

select current_timestamp from dual to see the session time

  
SQL> select current_timestamp from dual;



CURRENT_TIMESTAMP
------------------------------------------------------
26-OCT-09 10.31.37.075000 AM -06:00

1 row selected.

SQL>








Related examples in the same category

1.CURRENT_TIMESTAMP(): containing the current session time along with the session time zone
2.Insert a row using the CURRENT_TIMESTAMP function
3.Compare the timestamp value between before and after 'alter session set time_zone'