Outdated Version
You are viewing an older version of this section. View current production version.
CEIL
Rounds a number up to the next highest integer.
Syntax
CEIL ( expression )
CEILING ( expression )
Arguments
- expression: any valid numeric expression.
Return Type
Integer.
Examples
select ceil(98.6), ceiling(-98.6);
+------------+----------------+
| ceil(98.6) | ceiling(-98.6) |
+------------+----------------+
| 99 | -98 |
+------------+----------------+
