CEILING
Returns a number rounded up to the nearest integer.
MySQL 8.4
CEILING(num)- num
- Number to roundDECIMAL
Return value
An integer
Examples
Positive fraction
MySQL 8.4
SELECT CEILING(0.2);Negative fraction
MySQL 8.4
SELECT CEILING(-0.2);Whole number
MySQL 8.4
SELECT CEILING(3);Details
CEIL is a synonym for CEILING.
Negative numbers are rounded towards zero: CEILING(-1.2) returns -1.