SELECT * FROM t_violation_info WHERE ( DATE(UPDATED_TIME) = CURDATE() AND HOUR (UPDATED_TIME) < 16 ) OR ( DATE(UPDATED_TIME) = DATE_SUB(CURDATE(), INTERVAL 1 DAY) AND HOUR (UPDATED_TIME) >= 16 )
Mysql 查询昨天16:00至今天16:00之间的信息
原文：https://www.cnblogs.com/daihu/p/9958924.html
