ADD_MONTHS
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
ADD_MONTHS adds a given number of months to a given date.
Supported input column types: base_column -> DATE, months_column -> INT
Output column type: DATE
If the input date is last day of the month, the resulting date will be last day of the month.
Syntax
ADD_MONTHS ( table.base_column, table.months_column )
NULL handling
If any parameter is NULL, the result is NULL as well.
Date range: If a result of type DATE is outside the interval from the year 1400 CE (including) to the year 10000 CE (excluding), it will normally be mapped to NULL. This is not the case for this function:
Results outside the interval will still be DATE values.
However there are no longer any guarantees with regard to the correctness of the resulting values outside the interval.
Example
[1] Simple example for ADD_MONTHS.
|
[2] Simple example for ADD_MONTHS.
|
[3] ADD_MONTHS behaviour when input date is last day of the month. The resulting date is also end of the month. |