Outdated Version
You are viewing an older version of this section. View current production version.
FLOOR
Rounds a number down to the next lowest integer.
Syntax
FLOOR ( expression )
Arguments
- expression: any valid numeric expression.
Return Type
Integer.
Examples
select floor(98.6), floor(-98.6);
+-------------+--------------+
| floor(98.6) | floor(-98.6) |
+-------------+--------------+
| 98 | -99 |
+-------------+--------------+
