oracle 取整的几种方法 - 留着自个用
[b]1.取整(大)[/b]
select ceil(-1.001) value from dual -- -1
[b]2.取整(小)[/b]
select floor(-1.001) value from dual -- -2
[b]3.取整(截取)[/b]
select trunc(-1.002) value from dual -- -1
[b]4.取整(舍入)[/b]
select round(-1.001) value from dual -- -1
[b]1.取整(大)[/b]
select ceil(-1.001) value from dual -- -1
[b]2.取整(小)[/b]
select floor(-1.001) value from dual -- -2
[b]3.取整(截取)[/b]
select trunc(-1.002) value from dual -- -1
[b]4.取整(舍入)[/b]
select round(-1.001) value from dual -- -1