sql group by date code example

Example 1: mysql group by date

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

Example 2: How can I group by date time column without taking time into consideration

GROUP BY CAST(myDateTime AS DATE)