Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
ADD_HOURS adds a given number of hours to a given date.
Supported input column types: base_column -> DATE, hours_column -> INT
Output column type: DATE
ADD_HOURS ( table.base_column, table.hour_column )
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.
[1] Simple example for ADD_HOURS.
|