mysql用unix时间戳统计一个日期段的数据

select DATE_FORMAT(FROM_UNIXTIME(date),'%Y-%m-%d') as d, count(*) as c from tb
    where
    (FROM_UNIXTIME(date)) >= (FROM_UNIXTIME('1370275200')) and
    (FROM_UNIXTIME(date)) <= (FROM_UNIXTIME('1376074551'))
    group by d