group by date

Sometimes you may need to group by date on datetime column in MySQL. Here are the steps to do it.