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