sql时间戳按时间进行分组

sql语句，数据中存的时间戳，如何查询一段时间每天的统计

SELECT
	count(*) AS counter,timedate
FROM
	(
		SELECT
			*, date_format(
				from_unixtime(c.时间戳名),
				'%Y-%m-%d'
			) AS timedate
		FROM
			表名 AS c
	) temp
WHERE
	timedate >= '2015-01-06'
AND timedate <= '2015-11-08'
GROUP BY
	timedate