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