(1)round(数字[,小数位数]):按照指定小数位数,四舍五入,默认保留到整数位
SELECT round(3.1415927) FROM dual; --3
SELECT round(3.5415927) FROM dual; --4
SELECT round(3.5465927,2) FROM dual; --3.55
(2)trunc(数字[,小数位数]):截断到指定位数,不四舍五入,默认保留到整数位
SELECT trunc(3.1415927) FROM dual; --3
SELECT trunc(3.5415927) FROM dual; --3
SELECT trunc(3.5465927,2) FROM dual; --3.54
SELECT trunc(-3.5) FROM dual; --3
(3)floor(数字):返回不大于本身的最大整数
SELECT floor(-3.5) FROM dual; -- -4
(4)ceil(数字):进位取整
SELECT ceil(3.00000001) FROM dual; --4
SELECT ceil(3.0) FROM dual; --3
(5)mod(被除数,除数):求模
SELECT mod(5,3) FROM dual; --2