MySQL CEILING() Function
Example
Return the smallest integer value that is greater than or equal to 25.75:
SELECT CEILING(25.75);
Try it Yourself »
Definition and Usage
The CEILING() function returns the smallest integer value that is bigger than or equal to a number.
Note: This function is equal to the CEIL() function.
Syntax
CEILING(number)
Parameter Values
Parameter | Description |
---|---|
number | Required. A numeric value |
Technical Details
Works in: | From MySQL 4.0 |
---|
More Examples
Example
Return the smallest integer value that is greater than or equal to 25:
SELECT CEILING(25);
Try it Yourself »