当前月:
and DATE_FORMAT(a.createTime,'%Y%m') = DATE_FORMAT(CURDATE(),'%Y%m')
指定月:
<if test="month!=null and month!=''">
and DATE_FORMAT(a.createTime,'%Y-%m')=#{month}
</if>
两个指定时间间隔:
<if test="startDate!=null and startDate!=''and endDate!=null and endDate!=''">
and a.createTime between #{startDate} and #{endDate}
</if>