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