按时间戳查询
查询本周:
SELECT * FROM 表 WHERE YEARWEEK(DATE_FORMAT(FROM_UNIXTIME(时间字段/1000),’%Y-%m-%d’),1) = YEARWEEK(now(),1);
查询本月:
SELECT * FROM 表 WHERE DATE_FORMAT(FROM_UNIXTIME(时间字段/1000),’%Y%m’) = DATE_FORMAT(CURDATE(),’%Y%m’);
查询今天:
SELECT * FROM 表 WHERE to_days(FROM_UNIXTIME(时间字段/1000)) = to_days(now());