current_timestamp + numtoyminterval( 3, 'month' ) current_timestamp
SQL>
SQL>
SQL> select current_timestamp from dual;
CURRENT_TIMESTAMP
--------------------------------------
16-JUN-08 04.27.20.414000 PM -08:00
1 row selected.
SQL>
SQL> select current_timestamp + numtoyminterval( 3, 'month' ) current_timestamp from dual;
CURRENT_TIMESTAMP
--------------------------------------
16-SEP-08 04.27.20.514000000 PM -08:00
1 row selected.
SQL>
SQL> --
Related examples in the same category