Bug #17869 Week format %U error in DATE_FORMAT
Submitted: 2 Mar 2006 17:33 Modified: 2 Mar 2006 18:59
Reporter: Andrew Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.18-standard-log OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[2 Mar 2006 17:33] Andrew
Using the %U or %u in DATE_FORMAT() gives the same result. May have something to do with Jan-01-2006 falling on a Sunday?

How to repeat:
select date_format('2006-01-01', '%U  %V');

-- compared to --

select date_format('2005-01-01', '%U  %V');