mysql---重复的年月日时分秒转换为年月日并分组排序

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