일별 통계쿼리

일별 통계쿼리

SELECT 

    DATE_FORMAT(vote_date,'%Y-%m-%d'), COUNT(*)

FROM tb_vote 

GROUP BY

    DATE_FORMAT(vote_date,'%Y-%m-%d')

ORDER BY

    DATE_FORMAT(vote_date,'%Y-%m-%d');

//%Y-%m-%d일별

//%Y-%m월별

//%Y년별