From: Johan De Meersman Date: April 29 2010 12:30pm Subject: Re: Obtain week number between years List-Archive: http://lists.mysql.com/mysql/221470 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016367d6ce86944ed04855f4b9c --0016367d6ce86944ed04855f4b9c Content-Type: text/plain; charset=ISO-8859-1 group by week(yourdate) ? On Thu, Apr 29, 2010 at 2:12 PM, Tompkins Neil 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 --0016367d6ce86944ed04855f4b9c--