"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
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