Re: Probelm with date grouping

2005-12-02 Thread SGreen
"Shaun" <[EMAIL PROTECTED]> wrote on 12/02/2005 10:09:44 AM: > Hi, > > I am having a problem with using dates grouped by week where it spans over 2 > months. I would like the query to return all hours worked by week number, > however week 48 is causing problems because it spans 2 months - act

Probelm with date grouping

2005-12-02 Thread Shaun
Hi, I am having a problem with using dates grouped by week where it spans over 2 months. I would like the query to return all hours worked by week number, however week 48 is causing problems because it spans 2 months - actually I am presuming this is the problem! mysql> SELECT DATE_FORMAT(T.Da