FLOOR
Returns a number rounded down to the nearest integer.
MySQL 8.1
FLOOR(num)Parameters
- numDECIMAL
- Number to round
Return value
An integer
Examples
Positive fraction
MySQL 8.1
SELECT FLOOR(0.2);Negative fraction
MySQL 8.1
SELECT FLOOR(-0.2);Whole number
MySQL 8.1
SELECT FLOOR(3);Details
Negative numbers are rounded away from zero: FLOOR(-1.2) returns -2.