SingleStore DB

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 |
+-------------+--------------+