qq_42301302的博客

查询某个时间段的数据常用的方式有 //查询2020-09-18当天 SELECT * FROM t_user WHERE created_time between '2020-09-18 00:00:00' and '2020-09-18 23:59:59' //查询2020-09-18当天 SELECT * FROM t_user WHERE year(created_time ) = 2020 and month(created_time )= 09 and day(created_time )