<![CDATA[
and wi.alarm_time >=DATE_FORMAT(NOW(), '%Y-%m-%d')
and wi.alarm_time <DATE_ADD(DATE_FORMAT(NOW(), '%Y-%m-%d'),INTERVAL1 day)]]>
本月:
<![CDATA[
and wi.alarm_time>=DATE_ADD(curdate(),interval -day(curdate())+1 day)
and wi.alarm_time<DATE_ADD(last_day(curdate()),INTERVAL1 day)]]>
本周:
<![CDATA[
and wi.alarm_time>=date_sub(curdate(),INTERVALWEEKDAY(curdate())DAY)
and wi.alarm_time<date_sub(curdate(),INTERVALWEEKDAY(curdate())-7DAY)]]>
近七天:
<![CDATA[
and wi.alarm_time>=DATE_SUB(CURDATE(),INTERVAL6DAY)
and wi.alarm_time<DATE_ADD(DATE_FORMAT(NOW(),'%Y-%m-%d'),INTERVAL1 day)]]>