SELECT CURDATE() AS click_date,DATE_FORMAT(a.click_date,’%w’) week
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 1 DAY) AS click_date,DATE_FORMAT(a.click_date,’%w’) week
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 2 DAY) AS click_date,DATE_FORMAT(a.click_date,’%w’) week
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 3 DAY) AS click_date,DATE_FORMAT(a.click_date,’%w’) week
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 4 DAY) AS click_date,DATE_FORMAT(a.click_date,’%w’) week
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 5 DAY) AS click_date,DATE_FORMAT(a.click_date,’%w’) week
UNION ALL
SELECT DATE_SUB(CURDATE(), INTERVAL 6 DAY) AS click_date,DATE_FORMAT(a.click_date,’%w’) week
mysql查询最近一周每一天的日期
最新推荐文章于 2024-07-30 03:48:25 发布