ADD_YEARS
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_YEARS adds a given number of years to a given date.
Supported input column types: base_column -> DATE, years_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_YEARS ( table.base_column, table.years_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_YEARS.
|
[2] Leap years behaviour with ADD_YEARS.
|