Skip to main content

ceiling

ceiling

Description​

Returns values from the input arg rounded to the nearest equal or larger integer.

Syntax​

ceiling(arg)

Parameter​

arg supports the DOUBLE data type.

Return value​

Returns a value of the BIGINT data type.

Examples​

mysql> select ceiling(3.14);
+---------------+
| ceiling(3.14) |
+---------------+
|             4 |
+---------------+
1 row in set (0.00 sec)