| description |
|---|
Returns the value from the specifed expression rounded to the nearest equal or smaller integer. |
- numeric_expression: The number (
DOUBLE,FLOAT,INTEGER) used to compute the floor.
Examples
{% code title="FLOOR example" %}
SELECT FLOOR(0)
-- 0{% endcode %}
{% code title="FLOOR example" %}
SELECT FLOOR(45.76)
-- 45{% endcode %}
{% code title="FLOOR example" %}
SELECT FLOOR(-1.3)
-- -2{% endcode %}