D/MySQL
MySQL FLOOR()
yeon.Biju
2020. 3. 26. 21:24
FLOOR(X)
Returns the largest integer value not greater than X.
mysql> SELECT FLOOR(1.23), FLOOR(-1.23) ;
+-------------+--------------+
| FLOOR(1.23) | FLOOR(-1.23) |
+-------------+--------------+
| 1 | -2 |
+-------------+--------------+
1 row in set (0.00 sec)
mysql> SELECT CEIL(1.23) ;
+------------+
| CEIL(1.23) |
+------------+
| 2 |
+------------+
1 row in set (0.00 sec)
CEIL() 참조
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 | +------..
webobj.tistory.com