December 2002
Intermediate to advanced
928 pages
85h 29m
English
ADD_MONTHS (date,n)
Adds n months to the date date. Negative values of n subtract months from d. The following rules control whether or not the day of the month is affected:
If the original date represents the last day of its month, then the resulting date will be adjusted so that it is also the last day of the month.
If keeping the same day of the month results in an invalid date because the new month has fewer days than the original, then the day will be adjusted downward to fit the new month.