/* '%Y%m%d' 혹은 '%Y-%m-%d' */ select date_format(articleregdt, '%Y%m%d') as date, count(*) from article group by date_format(articleregdt, '%Y%m%d') order by date asc
/* '%Y%m%d' 혹은 '%Y-%m-%d' */ select date_format(articleregdt, '%Y%m%d') as date, count(*) from article group by date_format(articleregdt, '%Y%m%d') order by date asc