Back to Starrocks

ceiling

docs/en/sql-reference/sql-functions/math-functions/ceiling.md

4.1.0415 B
Original Source

ceiling

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

Syntax

Shell
ceiling(arg)

Parameter

arg supports the DOUBLE data type.

Return value

Returns a value of the BIGINT data type.

Examples

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