>>>>> "Juan" == Juan Riera <jriera@stripped> writes:
Juan> Hello,
Juan> I have been using this option (start week on monday) for weeks, and this is
Juan> a very helpful one for all those non-british using MySQL. However, my week
Juan> problem is different, as I need to group yearly sales data by week. This
Juan> week beggining *today* (monday 27-Sep) is on your week() function week #40,
Juan> however on ISO # is week #39 !
Could you please provide an example of your problem:
At least with my MySQL version (should be the same with almost all
MySQL versions):
mysql> select week("1999-09-27");
+--------------------+
| week("1999-09-27") |
+--------------------+
| 39 |
+--------------------+
1 row in set (0.01 sec)
Juan> As you may suppose, this is not the same for sales team! and I am been
Juan> requested to use ISO week # as it is used widely on Spain.
Juan> By the moment I am substracting one from week() result, but this will work
Juan> only to end december...
Juan> Will I see it on next MySQL version?
Regards,
Monty
