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_SECONDS adds a given number of seconds to a given date.
Supported input column types: base_column -> DATE, seconds_column -> INT
Output column type: DATE
Syntax
ADD_SECONDS ( table.base_column, table.seconds_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.
Examples
[1] Simple example for ADD_SECONDS.
Query
Column1
ADD_SECONDS ( "Table1"."Base_Column" , "Table1"."Second_Column" )
Output
Result
Column1 : DATE |
---|
Mon Jan 01 2018 00:01:00.000 |
Mon Jan 01 2018 00:00:01.000 |
Mon Jan 01 2018 00:00:00.000 |
Sun Dec 31 2017 23:59:59.000 |
Query
Column1
ADD_SECONDS ( {t 0 } , "Table1"."Seconds" )