mysql获取近7天,7周,7月,7年日期,更具当前时间获取近7天,7周,7月,7年日期
废话不多说,直接看图
1:根据表中最大时间获取近7天日期
SELECT
DATE_FORMAT(creattime, "%Y-%m-%d") b
FROM t_stock_realtime_inventory
WHERE
DATE_FORMAT(creattime, "%Y-%m-%d") > (
SELECT DATE_FORMAT(DATE_SUB((SELECT MAX(creattime) FROM t_stock_realtime_inventory), INTERVAL 7 DAY ),
"%Y-%m-%d") a
GROUP BY a )
GROUP BY
b
ORDER BY
b ASC
1.1根据当前时间获取最近7日日期
SELECT
date_sub( curdate( ), INTERVAL 7 DAY ) AS a UNION
SELECT
date_sub( curdate( ), INTERVAL 6 DAY ) AS a UNION
SELECT
date_sub( curdate( ), INTERVAL 5 DAY ) AS a UNION
SELECT
date_sub( curdate( ), INTERVAL 4 DAY ) AS a UNION
SELECT
date_sub( curdate( ), INTERVAL 3 DAY ) AS a UNION