Mega Code Archive

 

Categories / MySQL / Math

 

CEIL() and CEILING() return the smallest integer that is not less than the specified number

mysql> CEILING(<number>) mysql> mysql> SELECT CEILING(9.327); +----------------+ | CEILING(9.327) | +----------------+ |             10 | +----------------+ 1 row in set (0.00 sec)