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:
xxxxxxxxxx1
SELECT 2
COUNT(`creation_time`) AS `count`, 3
DATE_FORMAT(`creation_time`, '%Y-%m-%d') AS `day`4
FROM clients5
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:
