Adding two months to current date : ADD_MONTHS « Date Timezone « Oracle PL / SQL






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



           
       








Related examples in the same category

1.ADD_MONTHS: Schedule a number of months after the current date
2.Subtract Month from a given date
3.Adding one month to SYSDATE
4.Combine to_char with add_months
5.select add_months( sysdate, 12 ) "Next Year"
6.select add_months( sysdate, -12 ) "Last Year"