SELECT * from (SELECT DATE_FORMAT(time,'%Y-%m-%d') as times from measure where DATE_SUB(CURDATE(), INTERVAL 8 DAY) <= date(time))a GROUP BY a.times ORDER BY a.times desc
mysql---重复的年月日时分秒转换为年月日并分组排序
最新推荐文章于 2024-07-03 09:57:17 发布
SELECT * from (SELECT DATE_FORMAT(time,'%Y-%m-%d') as times from measure where DATE_SUB(CURDATE(), INTERVAL 8 DAY) <= date(time))a GROUP BY a.times ORDER BY a.times desc