View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 05:44 AM
Stefan Rybacki
 
Posts: n/a
Default 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-----
Reply With Quote