【无标题】

今天：
to_days(violation_time) = to_days(now());
昨天：
to_days(now()) - to_days(violation_time) < 1
这个周：
YEARWEEK( date_format( FROM_UNIXTIME( HOUR, ‘%Y-%m-%d %H:%i:%S’ ), ‘%Y-%m-%d %H:%i:%S’ ), 1 ) = YEARWEEK( now(), 7 )
上个周：
YEARWEEK(date_format(FROM_UNIXTIME( hour, ‘%Y-%m-%d %H:%i:%S’ ),‘%Y-%m-%d %H:%i:%S’),1) = YEARWEEK(now(),1)-1
近七天：
AND DATE_SUB(CURDATE(), INTERVAL 7 DAY ) < date ( avi.violation_time )
近30日：
DATE_SUB(CURDATE(), INTERVAL 30 DAY) < date( FROM_UNIXTIME( day_time ))