Hello.
Please, provide more information about your data structure and what would you
want to get from the query. These manual pages might be helpful:
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
http://dev.mysql.com/doc/mysql/en/group-by-functions.html
Jer
group by date_format(field_type_date,'%Y/%m' )
-Original Message-
From: Jerry Swanson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 20, 2005 1:08 PM
To: mysql@lists.mysql.com
Subject: Group by Month
I have query that pulls data between to dates. How to group the data by
month?
--
[snip]
I have query that pulls data between to dates. How to group the data by
month?
[/snip]
It would be better if you showed use the query, but heh...our mind
reading skills are getting pretty good. At the end of your query put the
line;
GROUP BY month
--
MySQL General Mailing List
For list a
Boy, that was easy. I just figured it out after sending the question:
mysql> SELECT period,hours FROM log GROUP BY MONTH(period);
-Original Message-
From: Forer, Leif
Sent: Tuesday, February 26, 2002 5:32 PM
To: '[EMAIL PROTECTED]'
Subject: group by month
There is a date column in a
