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