CURRENT_TIMESTAMP(): containing the current session time along with the session time zone : CURRENT_TIMESTAMP « Date Timezone « Oracle PL / SQL






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

CURRENT_TIMESTAMP(): containing the current session time along with the session time zone

 

SQL>
SQL> --CURRENT_TIMESTAMP(): containing the current session time along with the session time zone.
SQL>
SQL> SELECT CURRENT_TIMESTAMP FROM dual;

CURRENT_TIMESTAMP
---------------------------------------------------------------------------
16-SEP-06 08.35.05.062000 PM EST

SQL>








Related examples in the same category

1.Insert a row using the CURRENT_TIMESTAMP function
2.Compare the timestamp value between before and after 'alter session set time_zone'
3.select current_timestamp from dual to see the session time