Re: Grouping data by week? -----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Serge Rielau wrote:
>...
> GROUP BY YEAR(dt), WEEK(dt)
> Or week_iso() depending whether your week starts Sunday or Monday...
>
> Cheers
> Serge
>
On thing to mention. Looking at 01/01/2006 would give a wrong result, since the
year is 2006 but the week is 52 if the week starts on Monday.
Regards
Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1rc2 (MingW32)
iD8DBQFDvX09yeCLzp/JKjARAgNRAJ9ZtPkXIYJFFdjnjsDjmp20gdjghACZAfce
YCbJ3zKrFPPFNDBnl2bsaQU=
=0SIN
-----END PGP SIGNATURE----- |