Skip to main content
Version: 0.0.1

FLOOR

Categories: Math

FLOOR

Returns the value from the specifed expression rounded to the nearest equal or smaller integer.

Syntax​

FLOOR(numeric_expression NUMERIC) → INTEGER​

  • numeric_expression: The number (DOUBLE, FLOAT, INTEGER) for which you want to compute the floor.

Examples

{{< codeheader "FLOOR example" >}}

SELECT FLOOR(0)
-- 0

{{< codeheader "FLOOR example" >}}

SELECT FLOOR(45.76)
-- 45

{{< codeheader "FLOOR example" >}}

SELECT FLOOR(-1.3)
-- -2