Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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> --