Tricky 'GROUP BY' MySQL question

[webbgroup]

How would you group by dates in a table where the date shows up like this: \"2003-01-15 13:05\"

 

I already tried something like this without much success.

 

select time as TIME, count(*) as posts from table group by time REGEXP \"2003-01-%\";

 

Any suggestions??

[pallevillesen]

mysql> SELECT DATE_FORMAT(\'1997-10-04 22:23:00\', \'%Y-%m-%d\');

+------------------------------------------------+

| DATE_FORMAT(\'1997-10-04 22:23:00\', \'%Y-%m-%d\') |

+------------------------------------------------+

| 1997-10-04                                     |

+------------------------------------------------+

1 row in set (0.00 sec)



mysql> 

 

Use the date_format consistently throughout the query.

 

I think you should read the mysql manual about date functions:

 

http://www.mysql.com/doc/en/Date_and_time_..._functions.html

 

P., denmark

[webbgroup]

YOur the man! Thanks for your help

[effigy]

bio keeps the sql kicking