FLOOR¶

Calculates the largest integer smaller or equal to the numeric expression given.

Syntax¶

FLOOR ( expr )

Arguments¶

Parameter	Description
`expr`	Numeric expression

Returns¶

Returns the same type as the argument supplied.

When using the FLOOR floating point number scalar function, real arguments are automatically cast to double precision.

Notes¶

If the input value is NULL, the result is NULL.

Examples¶

`FLOOR` vs. CEILING / CEIL vs. ROUND ¶

numbers=> SELECT FLOOR(x), CEIL(x), ROUND(x)
.      FROM (VALUES (0.0001), (-0.0001)
.           , (PI()), (-2.718281), (500.1234)) as t(x);
floor | ceil | round
------+------+------
    0 |    1 |    -0
    3 |    4 |     3
   -3 |   -2 |    -3
  500 |  501 |   500