MySQL CEIL(), CEILING()

CEIL(X)

CEIL() is a synonym for CEILING()

 

CEILING(X)

Returns the smallest integer value not less than X.

 

 

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

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

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

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