Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query
optimization, and usability that you won’t want to miss.
Rounds a number down to the next lowest integer.
FLOOR ( expression )
Integer.
SELECT FLOOR(98.6), FLOOR(-98.6);
+-------------+--------------+
| FLOOR(98.6) | FLOOR(-98.6) |
+-------------+--------------+
| 98 | -99 |
+-------------+--------------+