Skip to main content

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

FLOOR example
SELECT FLOOR(0)
-- 0
FLOOR example
SELECT FLOOR(45.76)
-- 45
FLOOR example
SELECT FLOOR(-1.3)
-- -2