mysql 年月日时分秒 分组排序

SELECTYEAR (dy.publishTime) AS YEAR,MONTH (dy.publishTime) AS MONTH,DAY (dy.publishTime) AS DAY,HOUR (dy.publishTime) AS HOUR,SECOND (dy.publishTime) AS SECOND,COUNT(*) AS countFROMdynamicmessage AS dyWHEREdy.deleteflag = '1'AND DATE_FORMAT(dy.publishTime, '%Y-%m-%d ') > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 600 DAY),'%Y-%m-%d')AND DATE_FORMAT(dy.publishTime, '%Y-%m-%d ') < NOW()GROUP BYHOUR (dy.publishTime)ORDER BYYEAR ASC,MONTH ASC,DAY ASC,HOUR ASC,SECOND ASC