Какой режим для MySQL WEEK ()соответствует ISO 8601

Какой режим для MySQLWEEK()функция выдает неделю года по ISO 8601 ? Аргумент 2 WEEK()задает режим в соответствии с этой диаграммой:

+--------------------------------------------------------------------+
| Mode | First day of week | Range | Week 1 is the first week...    |
|------+-------------------+-------+---------------------------------|
| 0    | Sunday            | 0-53  | with a Sunday in this year      |
|------+-------------------+-------+---------------------------------|
| 1    | Monday            | 0-53  | with more than 3 days this year |
|------+-------------------+-------+---------------------------------|
| 2    | Sunday            | 1-53  | with a Sunday in this year      |
|------+-------------------+-------+---------------------------------|
| 3    | Monday            | 1-53  | with more than 3 days this year |
|------+-------------------+-------+---------------------------------|
| 4    | Sunday            | 0-53  | with more than 3 days this year |
|------+-------------------+-------+---------------------------------|
| 5    | Monday            | 0-53  | with a Monday in this year      |
|------+-------------------+-------+---------------------------------|
| 6    | Sunday            | 1-53  | with more than 3 days this year |
|------+-------------------+-------+---------------------------------|
| 7    | Monday            | 1-53  | with a Monday in this year      |
+--------------------------------------------------------------------+

Будет ли один из этих режимов давать ISO 8601 неделю года?

44
задан steampowered 3 August 2012 в 22:25
поделиться