CEILING(X), CEIL(X) returns the smallest integer value not less than X. : CEILING « Math Numeric Functions « MySQL Tutorial






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

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








21.10.CEILING
21.10.1.CEILING(X), CEIL(X) returns the smallest integer value not less than X.
21.10.2.Ceiling a column