Product Solutions Support
Try MemSQL

FLOOR

Rounds a number down to the next lowest integer.

FLOOR ( expression )

Arguments

Return Type

Integer.

Examples

memsql> select floor(98.6), floor(-98.6);
+-------------+--------------+
| floor(98.6) | floor(-98.6) |
+-------------+--------------+
|          98 |          -99 |
+-------------+--------------+
Was this article useful?