Skip to main content

FLOOR

Returns the largest integer value not greater than x.

Syntax​

FLOOR(x)

Arguments​

ArgumentsDescription
xThe numerical value.

Return Type​

A Float64 data type value.

Examples​

mysql> SELECT FLOOR(1.23);
+-------------+
| FLOOR(1.23) |
+-------------+
|           1 |
+-------------+
1 row in set (0.01 sec)

mysql> SELECT FLOOR(-1.23);
+-----------------+
| FLOOR((- 1.23)) |
+-----------------+
|              -2 |
+-----------------+
1 row in set (0.01 sec)