Using group by date and count

[bobb]

Is there a way to select count(*) by grouping by date, and having multiple
date ranges?

combining...

select field,count(*) from table where datefield > 2004/1/1 and datefield <
2004/1/31
and
select field,count(*) from table where datefield > 2004/2/1 and datefield <
2004/2/29
so that the output is

field 34
field 40
tia

bobb

[Aggro]

bobb wrote:

Is there a way to select count(*) by grouping by date, and having multiple
date ranges?

Do you mean random date ranges (if yes, then how many ranges are we
talking about, and is the amount of ranges always the same?)

Or do you mean you want to group for example by year and month? If yes,
this might be a little easier because you can extract year and month
from date and then do "group by year, month" or "group by year_month"

Example:
mysql> SELECT EXTRACT(YEAR_MONTH FROM '1999-07-02 01:02:03');
-> 199907

More date and time functions:
http://www.mysql.com/doc/en/Date_and...functions.html

[bobb]

thanks Aggro,
I'm grouping the results by month... thanks for the pointer.
bobb

"Aggro" <sp**********@yahoo.com> wrote in message
news:up*************@read3.inet.fi...

bobb wrote:

Is there a way to select count(*) by grouping by date, and having multiple date ranges?

Do you mean random date ranges (if yes, then how many ranges are we
talking about, and is the amount of ranges always the same?)

Or do you mean you want to group for example by year and month? If yes,
this might be a little easier because you can extract year and month
from date and then do "group by year, month" or "group by year_month"

Example:
mysql> SELECT EXTRACT(YEAR_MONTH FROM '1999-07-02 01:02:03');
-> 199907

More date and time functions:
http://www.mysql.com/doc/en/Date_and...functions.html

[bobb]

thanks Aggro,
I'm grouping the results by month... thanks for the pointer.
bobb

"Aggro" <sp**********@yahoo.com> wrote in message
news:up*************@read3.inet.fi...

bobb wrote:

Is there a way to select count(*) by grouping by date, and having multiple date ranges?

Do you mean random date ranges (if yes, then how many ranges are we
talking about, and is the amount of ranges always the same?)

Or do you mean you want to group for example by year and month? If yes,
this might be a little easier because you can extract year and month
from date and then do "group by year, month" or "group by year_month"

Example:
mysql> SELECT EXTRACT(YEAR_MONTH FROM '1999-07-02 01:02:03');
-> 199907

More date and time functions:
http://www.mysql.com/doc/en/Date_and...functions.html

[bobb]

thanks Aggro,
I'm grouping the results by month... thanks for the pointer.
bobb

"Aggro" <sp**********@yahoo.com> wrote in message
news:up*************@read3.inet.fi...

bobb wrote:

Is there a way to select count(*) by grouping by date, and having multiple date ranges?

Do you mean random date ranges (if yes, then how many ranges are we
talking about, and is the amount of ranges always the same?)

Or do you mean you want to group for example by year and month? If yes,
this might be a little easier because you can extract year and month
from date and then do "group by year, month" or "group by year_month"

Example:
mysql> SELECT EXTRACT(YEAR_MONTH FROM '1999-07-02 01:02:03');
-> 199907

More date and time functions:
http://www.mysql.com/doc/en/Date_and...functions.html