How to count occurrences of date only in a field that contains datetime data?
You just need to format the timestamp so it only shows the day, then group by that:

select date_format(foo_timestamp,'%Y-%m-%d'), count(*)
from foo_table
group by 1
order by 1;