SQL Function Reference

FLOOR

Returns a number rounded to a smaller integer

MySQL

FLOOR(num)

Examples

MySQL

SELECT FLOOR(-0.2);

MySQL

SELECT FLOOR(0.2);

MySQL

SELECT FLOOR(3);