Skip to main content
Skip to main content

ceil

ceil​

description​

Syntax​

BIGINT ceil(DOUBLE x) Returns the smallest integer value greater than or equal to x.

tip

The other alias for this function are dceil and ceiling.

example​

mysql> select ceil(1);
+-----------+
| ceil(1.0) |
+-----------+
| 1 |
+-----------+
mysql> select ceil(2.4);
+-----------+
| ceil(2.4) |
+-----------+
| 3 |
+-----------+
mysql> select ceil(-10.3);
+-------------+
| ceil(-10.3) |
+-------------+
| -10 |
+-------------+

keywords​

CEIL, DCEIL, CEILING