PL/SQL Add_Months
Oracle PL/SQL Add_Months Function
The Add_Months returns a date which is argument plus number of months.
The Add_Months Function syntax:
add_months (argument, number);
Example:
Select add_months('01-Mar-08', 2) From dual; 01-05-2008 Select add_months('01-Mar-08', -2) From dual; 01-01-2008