DevHeads.net

Obtain week number between years

By Tompkins Neil at 04/29/2010 - 08:12

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

Comments

Re: Obtain week number between years

By Johan De Meersman at 04/29/2010 - 08:30

group by week(yourdate) ?

On Thu, Apr 29, 2010 at 2:12 PM, Tompkins Neil <neil. ... at googlemail dot com