CURRENT_TIMESTAMP « Date Timezone « Oracle PL / SQL






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'
4.select current_timestamp from dual to see the session time