FLOOR
Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6 CELONIS 4.7
Description
The FLOOR function returns the greatest integer smaller than, or equal to, the specified numeric expression.
It can be applied to FLOAT columns. The result is a column of type INT.
Syntax
FLOOR ( table.column )
NULL handling
If the input value is NULL, the result is NULL as well.
Example
[1] FLOOR of FLOAT column with one negative value and one null value. |