ORACLE - Date Functions : Add_Months

The add_months function returns a date plus number months.
The syntax is:
add_months( date, number )

date : is the starting date (before the n months have been added).
number : is the number of months to add to date.

Example:
add_months('10-Feb-08', 1) would return '10-Mar-08'
add_months('01-Aug-03', 3) would return '01-Nov-03'
add_months('01-Sep-08', -3) would return '01-Jun-08'

Applies To:
* Oracle 8i
* Oracle 9i
* Oracle 10g
* Oracle 11g

No hay comentarios: