排序条件:
1:周一三点到下周一三点为一周事件,周一为一周结束点
yearweek(
date_format(
DATE_SUB(
`tests`.`updated_at`,
INTERVAL 3 HOUR
),
'%Y-%m-%d'
), 1) = (yearweek(now(), 1) - 1)
2:指定21:00:00-03:00:00之间的数据
TIMEDIFF(date_format(`tests`.`updated_at`, '%H:%i:%s'), '21:00:00') > 0
OR
TIMEDIFF(date_format(`tests`.`updated_at`, '%H:%i:%s'), '03:00:00') < 0
3:按照时分秒正序
ORDER BY date_format(`tests`.`updated_at`, '%H:%i:%s')