HOURS_BETWEEN
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
HOURS_BETWEEN computes the difference between two dates in hours.
Supported input column types: DATE
Output column type: FLOAT
Syntax
HOURS_BETWEEN ( table.column1, table.column2 )
NULL handling
If any parameter is NULL, the result is NULL as well.
Example
[1] HOURS_BETWEEN of two rows. |