13:19:01 SQL> select round(5/3,3) from dual;ROUND(5/3,3)
------------
1.667实际:60
13:19:17 SQL> select floor(5/3) from dual;FLOOR(5/3)
----------
1实际:20
13:19:32 SQL> select trunc(5/3,3) from dual;TRUNC(5/3,3)
------------
1.666实际:20
13:19:50 SQL>
------------
1.667实际:60
13:19:17 SQL> select floor(5/3) from dual;FLOOR(5/3)
----------
1实际:20
13:19:32 SQL> select trunc(5/3,3) from dual;TRUNC(5/3,3)
------------
1.666实际:20
13:19:50 SQL>
round:四舍五入
floor:小于数最大整数
ceil:大于数最小整数