Syntax
CEILING(X)
Purpose
Returns the smallest integer greater than or equal to X. This function is an alias for CEIL().
Supports comparison operations, returning a BOOL value that is converted to a numeric type. The result is 1 (TRUE) or 0 (FALSE).
If the input is NULL, the return value is NULL.
If the input is a string of pure digits, it is automatically converted to a numeric type.
The return value is converted to a BIGINT.
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