ORACLE - Date Functions: Add_Months
The function add_months start date plus the number of months accordingly.
The syntax is:
add_months (date, number months)
date: is the eating of the calculation date (before the n months Have Been added).
number of months: the number of months that must be added 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 '
Apply:
* Oracle 8i
* Oracle 9i * Oracle 10g
* Oracle 11g
0 comments:
Post a Comment