Date Grouping

[The Little Guy]

How can I group by date?

 

in the database, I have this: YYYY-MM-DD HH:MM:SS

 

I only want to group by this: YYYY-MM-DD

 

how can I do that?

[The Little Guy]

Currently I have this:

 

SELECT COUNT(*) as c, date FROM `stats` 
WHERE 
DATE_SUB(CURDATE(),INTERVAL 20 DAY) AND
owner_id = '1'
AND
project_id = '6'
GROUP BY date = 'YYYY-MM-DD' ORDER BY date DESC

 

It sorta works...

 

It is getting all the vals and grouping them into one.... I have two different days in there:

 

I have:

2008-09-13

and

2008-09-14

 

there are 7 rows total, 6 are day 13 and 1 is day 14, but it shows 7 in one row...

[fenway]

Your group by expression doesn't make any sense... why not use DATE().