查询当年当月的数据:
select * from compalete_task
where to_Char(create_date,'yyyyMM') = to_Char(sysdate,'yyyyMM')
order by create_date desc;
查询当年当月的数据:
select * from compalete_task
where to_Char(create_date,'yyyyMM') = to_Char(sysdate,'yyyyMM')
order by create_date desc;