Hi guys,

I have a timestamp field like: 2011-01-03 18:29:44

I want to get how many rows for each date,

ie:
select count(*) from table group by time;

However this obviously returns a lot of rows ( as its counting the hours and miniutes )

How can i get it to just group by 2011-01-03 rather than 2011-01-03 18:29:44

Ie: group by yyyy-mm-dd rather than yyyy-mm-dd hh:mm:ss


Google isnt being too helpful.

Thanks
G

Well well,
With no answers ive spent the best part of all day hunting for the best way to do it.

This is what i have ( and works )

SELECT DATE_FORMAT(DATE(time ) , '%m/%d/%y' ) , COUNT( time ) AS counted
FROM visitors
GROUP
BY DATE( time )


Thought id share for others having the same issue one day.

select count(1), to_char(date_field, "yyyy-mm-dd") from visitors group by to_char(date_field, "yyyy-mm-dd") ;

Thanks Paul. Better late than never lol

Always welcome other ways to do things..
I wonder which way will be more cpu intensive?