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) used to compute the floor.

Examples

FLOOR example

SELECT FLOOR(0)
-- 0

FLOOR example

SELECT FLOOR(45.76)
-- 45

FLOOR example

SELECT FLOOR(-1.3)
-- -2