floor, dfloor

docs/en/sql-reference/sql-functions/math-functions/floor.md

4.1.0369 B

Returns the largest integer that is not more than x.

Syntax

SQL

FLOOR(x);

x: DOUBLE is supported.

Returns a value of the BIGINT data type.

Plaintext

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