floor, dfloor

Returns the largest integer that is not more than x.

Syntax

FLOOR(x);

Parameters

x: DOUBLE is supported.

Return value

Returns a value of the BIGINT data type.

Examples

mysql> select floor(3.14);
+-------------+
| floor(3.14) |
+-------------+
|           3 |
+-------------+
1 row in set (0.01 sec)