pril 29, 2010 8:34 AM
> To: MySql
> Subject: Re: Obtain week number between years
>
> Neil,
>
> I would start with something like this, assuming the date column is
> called "d":
>
> SELECT
> FROM
> GROUP BY d - INTERVAL DAYOFWEEK(d) DAY;
>
>
Neil,
I would start with something like this, assuming the date column is called "d":
SELECT
FROM
GROUP BY d - INTERVAL DAYOFWEEK(d) DAY;
- Baron
On Thu, Apr 29, 2010 at 8:12 AM, Tompkins Neil
wrote:
> Hi
>
> We need to produce a query to return the total number of user visits between
> two
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
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 200
