group by week(yourdate) ?
On Thu, Apr 29, 2010 at 2:12 PM, Tompkins Neil <neil.tompk...@googlemail.com > 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 > -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel