MySQL Function Reference

CEILING

Returns a number rounded to a larger integer

MySQL 8.1

CEILING(num)

Examples

MySQL 8.1

SELECT CEILING(0.2);

MySQL 8.1

SELECT CEILING(-0.2);

MySQL 8.1

SELECT CEILING(3);