FLOOR
On this page
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 |
+-------------+--------------+Last modified: February 24, 2023