List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:April 29 2010 12:33pm
Subject:Re: Obtain week number between years
View as plain text  
Neil,

I would start with something like this, assuming the date column is called "d":

SELECT <count, or sum, or whatever aggregate function>
FROM <table>
GROUP BY d - INTERVAL DAYOFWEEK(d) DAY;

- Baron

On Thu, Apr 29, 2010 at 8:12 AM, Tompkins Neil
<neil.tompkins@stripped> wrote:
> Hi
>
> We need to produce a query to return the total number of user visits between
> two date ranges that span over two year e.g from 2009-04-29 to 2010-04-29.
> My question is how can I compute the totals for each week within a query ?
> for example
>
> 2009-04-29 to 2009-05-06   100 visits
> 2009-05-07 to 2009-05-14   250 visits etc
>
> Cheers
> Neil
>



-- 
Baron Schwartz
Percona Inc <http://www.percona.com/>
Consulting, Training, Support & Services for MySQL
Thread
Obtain week number between yearsTompkins Neil29 Apr
  • Re: Obtain week number between yearsJohan De Meersman29 Apr
  • Re: Obtain week number between yearsBaron Schwartz29 Apr
    • RE: Obtain week number between yearsSteven Staples29 Apr