Friday, August 29, 2008

Churchsample Letter Free

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