Hello,
I have been using this option (start week on monday) for weeks, and this is
a very helpful one for all those non-british using MySQL. However, my week
problem is different, as I need to group yearly sales data by week. This
week beggining *today* (monday 27-Sep) is on your week() function week #40,
however on ISO # is week #39 !
As you may suppose, this is not the same for sales team! and I am been
requested to use ISO week # as it is used widely on Spain.
By the moment I am substracting one from week() result, but this will work
only to end december...
Will I see it on next MySQL version?
Regards,
Juan
>
> Note that both the WEEK() function and DATE_FORMAT() can handle weeks
> that starts with Sunday or Monday (another way too look at your week
> problem).
>
> Just take a look in the MySQL manual for the above functions!
>
> Regards,
> Monty
>
