Skip to main content

Celonis Product Documentation

FLOOR
Description

The FLOOR function returns the greatest integer smaller than, or equal to, the specified numeric expression.

It can be applied to FLOAT columns or INT 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:

Query

Column1

         FLOOR ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : float

0.1

0.9

-1.1

0.0

null

Result

Column1 : int

0

0

-2

0

null

[2]

FLOOR has no effect on an INT column:

Query

Column1

         FLOOR ( "Table1"."Column1" )
        

Input

Output

Table1

Column1 : int

1

9

-1

0

null

Result

Column1 : int

1

9

-1

0

null

See also: