웹이야기

MySQL FLOOR() 본문

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() 참조

https://webobj.tistory.com/94

 

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

 

'D > MySQL' 카테고리의 다른 글

MySQL RAND()  (0) 2020.03.26
MySQL MOD()  (0) 2020.03.26
MySQL CONV()  (0) 2020.03.26
MySQL CEIL(), CEILING()  (0) 2020.03.26
MySQL ABS()  (0) 2020.03.26
'D/MySQL' Related Articles more
Comments