Skip to main content
Version: Latest-3.3

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)