ADD_MILLIS
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_MILLIS adds a given number of milliseconds to a given DATE.
Supported input column types: base_column -> DATE, milliseconds_column -> INT
Output column type: DATE
Syntax
ADD_MILLIS ( table.base_column, table.milliseconds_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_MILLIS.
|