For some weeks I have been trying to find alternatives to week() function on
MySQL allowing to format dates (datetime field) as week number using ISO
format (first week of the year is week with the first thursday on it, or
week with four complete days). I have found perl and PHP alternatives, but I
definitely need a MySQL function as I need to group data on SQL query, and
not only formatting dates. As I am not a C programmer, I have not tried to
develop a MySQL function to do this date formatting, but I wonder if (a)
could it be done, and (b) has anyone a valid alternative for grouping values
on iso week number as a result of an MySQL query.
Anyway, I send to you my humble request to find this option on new MySQL
versions as a new option added to week() function!