mysql 年月日时分秒 分组排序

SELECT
	YEAR (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 count
FROM
	dynamicmessage AS dy
WHERE
	dy.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 BY
	HOUR (dy.publishTime)
ORDER BY
	YEAR ASC,
	MONTH ASC,
	DAY ASC,
	HOUR ASC,
	SECOND ASC