之前用的比较多有round、ceil、floor,之前也用过一次trunc,没来及的总结,今天总结一下trunc函数
select trunc(123.456789) from dual;
123
select trunc(123.456789,4) from dual;
123.4567
select trunc(123.456789,5) from dual;
123.45678
select trunc(123.456789,-1) from dual;
120
select trunc(123.456789,-2) from dual;
TRUNC(123.456789,-2)
--------------------
100
select trunc(123.456789,-3) from dual;
TRUNC(123.456789,-3)
--------------------
0
日期
select sysdate from dual;
2019-03-26 15:03:35
select trunc(sysdate) from dual;
2019-03-26 00:00:00
第二个参数可以为负数,表示为小数点左边指定位数后面的部分截去,即均以0记。与取整类似,比如参数为1即取整到十分位,如果是-1,则是取整到十位,以此类推;如果所设置的参数为负数,且负数的位数大于或等于整数的字节数的话,则返回为0。如:TRUNC(89.985,-3)=0。