mysql group by date
snippet in sql

mysql group by day

user1762

GROUP BY DATE_FORMAT(record_date, '%Y%m')

mysql group by date

user8248

SELECT SUM(foo), DATE(mydate) FROM a_table GROUP BY DATE(a_table.mydate);