Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. 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> --