1 of 1

FLOOR

Round down to the nearest integer. This function returns the largest integer value that is less than or equal to the argument.

Syntax

FLOOR(X)

Description

Returns the largest integer value not greater than X.

Examples

_{This page is licensed: GPLv2, originally from}

SELECT FLOOR(1.23);
+-------------+
| FLOOR(1.23) |
+-------------+
|           1 |
+-------------+

SELECT FLOOR(-1.23);
+--------------+
| FLOOR(-1.23) |
+--------------+
|           -2 |
+--------------+