On Wednesday, 15. May 2002 14:54, Mattias Persson wrote: > query above. The manual says > > %v Week (1..53), where Monday is the first day of the week. Used with '%x' > %u Week (0..53), where Monday is the first day of the week > > When is there a week 0?
Hi, Week = 0 only is valid for %u. %v means January 1st is always in the 1st week, regardless which weekday it is. (1st Week: January 1st - until next sunday after January 1st %u means: The 1st week in January starts with first monday. So all before 1st monday is week 0. (Saturday Januar 1st = week 0, Monday January 3d is week 1) Regards Georg --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php