MySQL Function Reference

FLOOR

Returns a number rounded to a smaller integer

MySQL 8.1

FLOOR(num)

Examples

MySQL 8.1

SELECT FLOOR(-0.2);

MySQL 8.1

SELECT FLOOR(0.2);

MySQL 8.1

SELECT FLOOR(3);