今天:
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 ))
【无标题】
最新推荐文章于 2024-07-12 00:29:24 发布