>> PHP handles this correctly -- if I do a date("W-y", $date)
>> for '2001-12-31'
>> I get '01-02', but in mysql you get the wrong year: '01-01'
>
>I don't know where you got this data from, but the second number would be
the year, that means mysql is showing the right year and php is showing the
Mysql gives what I'd call incorrect output when outputing week and years at
the end of the year.
PHP handles this correctly -- if I do a date("W-y", $date) for '2001-12-31'
I get '01-02', but in mysql you get the wrong year: '01-01'
Here's the an example (the second one is not what I'd expect):