Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Adding two months to current date

SQL> SQL> SQL> -- Adding two months to SYSDATE. SQL>  SELECT ADD_MONTHS(SYSDATE,2) from DUAL; ADD_MONTH --------- 31-OCT-06