EN
MySql - group rows by days
1 points
In this short article we would like to show how in MySql group rows by days.
Sql example:
xxxxxxxxxx
1
SELECT
2
COUNT(`creation_time`) AS `count`,
3
DATE_FORMAT(`creation_time`, '%Y-%m-%d') AS `day`
4
FROM clients
5
GROUP BY YEAR(`creation_time`), MONTH(`creation_time`), DAY(`creation_time`)
Note:
YEAR(`creation_time`)
andMONTH(`creation_time`)
prevents rows mixing when months come from different years.
Screenshot:
