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 |
+------------+----------------+