Oracle trunc 使用

 

       TRUNC() 函数使用

                 一、对日期的支持

                             1.select trunc(sysdate) from dual; --返回当前时间  yyyy-mm-dd

                             2.select trunc(sysdate, 'mm')  from dual; --返回当月第一天.

                             3.select trunc(sysdate,'yy') from dual;  --返回当年第一天

                             4.select trunc(sysdate,'dd') from dual;  --返回当前年月日

                             5.select trunc(sysdate,'yyyy') from dual;  --返回当年当月第一天

                             6.select trunc(sysdate,'d') from dual;  --返回当前星期的第一天（注意是：星期天）

                             7.select trunc(sysdate, 'hh') from dual;  --返回当前时间加小时

                             8.select trunc(sysdate, 'mi') from dual;--返回当前时间加小时，分钟

 

                             ----TRUNC()函数没有精确到秒

 

                二、对数值的支持

                             trunc(number,num_prec)

                             number : 要处理的数值

                             num_prec : 小数点后保留的精度数     默认值为：0

 

 

              1.select trunc(45454.123) from dual; --45454

              2.select trunc(45454.123,0) from dual; --45454

              3.select trunc(45454.123,1) from dual;--45454.1

              4.select trunc(45454.123,-1) from dual; --45450

              5.select trunc(45454.123,-4) from dual; --40000

              6.select trunc(45454.123,4) from dual;  --45454.123

              7.select trunc(45454) from dual;  --45454

              8.select trunc(45454.123,1) from dual; --45454.1

 

                               ----整理至网络