sql条件查询-日期比较(取年月部分)时间:2023-03-10 07:24:01 查询当年当月的数据: select * from compalete_task where to_Char(create_date,'yyyyMM') = to_Char(sysdate,'yyyyMM')order by create_date desc;