- Floor(n)
- 作用
返回小于等于n的最大整数 - 例子
- 作用
SELECT FLOOR(15.1) FROM dual;
FLOOR(15.1)
-----------
15
SELECT FLOOR(-15.1) FROM dual;
FLOOR(-15.1)
------------
SELECT FLOOR(0.1) FROM dual;
FLOOR(0.1)
----------
0
sql> SELECT FLOOR(0.9) FROM dual;
FLOOR(0.9)
----------
0
SELECT FLOOR(-0.1) FROM dual;
FLOOR(-0.1)
-----------
-1