Basically, I want sub-totals by day.

I would like to count the number of occurrances of any rows with a particular column value, and show a separate count for each day. We have a table that uses a timestamp to differentiate the date and time. I thought I could use the COUNT function combined with GROUP BY. But I'm not sure how to group all rows with a timestamp for the same day. I thought of use using the DAY function, but I can't seem to group by that ( or I'm not using the correct...