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

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

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

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