oracle trunc 函数

--  
select trunc(to_date('2018-02-01 1:00:00','YYYY-MM-DD HH:MI:SS'),'yyyy') from dual ;--返回当年第一天  2018/1/1
select trunc(to_date('2018-02-01 1:00:00','YYYY-MM-DD HH:MI:SS'),'mm') from dual ; --返回当月第一天  2018/2/1
select trunc(to_date('2018-02-01 1:00:00','YYYY-MM-DD HH:MI:SS'),'dd') from dual ;--返回当前年月     2018/2/1
select trunc(to_date('2018-02-01 1:00:00','YYYY-MM-DD HH:MI:SS'),'d') from dual ; --返回当前星期的第一天(星期日) 2018/1/28
select trunc(to_date('2018-02-01 1:12:12','YYYY-MM-DD HH:MI:SS'),'hh') from dual ;--返回当前日期截取到小时,分秒补0  2018/2/1 1:00:00
select trunc(to_date('2018-02-01 1:12:12','YYYY-MM-DD HH:MI:SS'),'mi') from dual ;--返回当前日期截取到分,秒补0   2018/2/1 1:12:00

 select Q.SLWD || Q.TXNUM AS channelIndexNo, Q.csrq AS csrq
  from QRPERSONAPPLY Q
 where (trunc((to_char(sysdate, 'yyyyMMdd') -
               to_char(to_date(Q.csrq, 'yyyy-MM-dd'), 'yyyyMMdd')) / 10000) >= 60 )         
 --
  select  Q.csrq AS csrq,
  trunc((to_char(sysdate, 'yyyyMMdd') - to_char(to_date(Q.csrq, 'yyyy-MM-dd'), 'yyyyMMdd')) / 10000) as tt,
  to_char(sysdate, 'yyyyMMdd') as t1 ,
  to_char(to_date(Q.csrq, 'yyyy-MM-dd'), 'yyyyMMdd') as t2,
  to_char(sysdate, 'yyyyMMdd') - to_char(to_date(Q.csrq, 'yyyy-MM-dd'), 'yyyyMMdd') as t3,
  trunc(to_char(sysdate, 'yyyyMMdd') - to_char(to_date(Q.csrq, 'yyyy-MM-dd'), 'yyyyMMdd'))
  from QRPERSONAPPLY Q   
   
  select 20190716- 19590717 from dual --599999                 
select to_char(sysdate, 'yyyyMMdd') from dual   -- 20190716 
select  to_char(to_date(Q.csrq, 'yyyy-MM-dd'), 'yyyyMMdd') ,Q.csrq as csrq  from QRPERSONAPPLY Q -- 19590513  19590513 
select  to_date(Q.csrq, 'yyyy-MM-dd')  ,Q.csrq as csrq  from QRPERSONAPPLY Q  --  1959/5/13     19590513