how to group by datetime mysql with just date code example

Example: mysql group by date

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