Skip to main content

CEIL

CEIL() is a synonym for CEILING().

Returns the smallest integer value not less than x.

Syntax​

CEIL(x)

Arguments​

ArgumentsDescription
xThe numerical value.

Return Type​

A Float64 data type value.

Examples​

mysql> SELECT CEIL(1.23);
+------------+
| CEIL(1.23) |
+------------+
| 2 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT CEIL(-1.23);
+----------------+
| CEIL((- 1.23)) |
+----------------+
| -1 |
+----------------+
1 row in set (0.00 sec)