Syntax
CEILING(X)
Purpose
CEILING() returns the smallest integer that is greater than or equal to X. This function is the alias for the CEIL() function.
Comparison operations are supported. The comparison result is a Boolean value, which is converted into a numeric value. The result is 1 (TRUE) or 0 (FALSE).
If you enter NULL, NULL is returned.
If you enter a string of digits, it can be automatically converted into a numeric value.
The return value is converted into a BIGINT value.
Examples
obclient> SELECT CEILING(1.23);
+---------------+
| CEILING(1.23) |
+---------------+
| 2 |
+---------------+
1 row in set
obclient> SELECT CEILING(-1.23);
+----------------+
| CEILING(-1.23) |
+----------------+
| -1 |
+----------------+
1 row in set
