current_timestamp + numtodsinterval( 2, 'hour' ) : numtodsinterval « Date Timezone « Oracle PL / SQL






current_timestamp + numtodsinterval( 2, 'hour' )

 
SQL>
SQL>
SQL>  column current_timestamp format a38
SQL>  select current_timestamp from dual;
CURRENT_TIMESTAMP
--------------------------------------
16-JUN-08 04.27.20.203000 PM -08:00

1 row selected.

SQL>  select current_timestamp + numtodsinterval( 2, 'hour' ) current_timestamp from dual;
CURRENT_TIMESTAMP
--------------------------------------
16-JUN-08 06.27.20.284000000 PM -08:00

1 row selected.

SQL>
SQL> --

 








Related examples in the same category

1.NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit
2.numtodsinterval(150, 'DAY')
3.numtodsinterval(1500, 'HOUR')
4.NUMTODSINTERVAL(3.25, 'HOUR')
5.numtodsinterval(15000, 'MINUTE')
6.numtodsinterval(150000, 'SECOND')
7.current_timestamp + numtoyminterval( 3, 'month' ) current_timestamp