date_sub与datediff
https://www.nowcoder.com/practice/a78cf92c11e0421abf93762d25c3bfad
出错的地方: 近30天内,第一次where 后跟的条件是这样的:
start_time >= DATE_SUB((SELECT MAX(start_time) FROM tb_user_video_log),29)
但一直报错,后来发现缺了”天“的意思表达。应该写成这样:
start_time >= DATE_SUB((SELECT MAX(start_time) FROM tb_user_video_log),INTERVAL 30 day)
除了用date_sub语法外,也可以用DATEDIFF:
DATEDIFF((SELECT MAX(start_time) FROM tb_user_video_log),start_time)<=29