Returns the value from the specifed expression rounded to the nearest equal or smaller integer.
FLOOR(numeric_expression NUMERIC) → INTEGER
- numeric_expression: The number (DOUBLE, FLOAT, INTEGER) for which you want to compute the floor.
SELECT FLOOR(0) -- 0
SELECT FLOOR(45.76) -- 45
SELECT FLOOR(-1.3) -- -2
Was this page helpful?
Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.