SQL> select trunc(1.23) from dual;TRUNC(1.23)
-----------
1SQL> select round(1.23) from dual;ROUND(1.23)
-----------
1SQL> select floor(1.23) from dual;FLOOR(1.23)
-----------
1这几个都可以.
-----------
1SQL> select round(1.23) from dual;ROUND(1.23)
-----------
1SQL> select floor(1.23) from dual;FLOOR(1.23)
-----------
1这几个都可以.
截取;trunc(m,n)