Bug #25610 documentation for DATE_FORMAT %m range is confusing
Submitted: 13 Jan 2007 18:50 Modified: 13 Jan 2007 19:44
Reporter: Glenn Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0 OS:n/a
Assigned to: Paul DuBois CPU Architecture:Any

[13 Jan 2007 18:50] Glenn 
Description:
In Section 12.5 of the MySQL Reference Manual, in the description of
the DATE_FORMAT function, the %m format specifier is documented as
having a range of 00..12.  Inasmuch as this range encompasses 13
values, the documentation is either confusing or wrong.  Most readers
are only familiar with the Gregorian calendar, which has only 12 months.

How to repeat:
Read the manual.

Suggested fix:
Fix the documentation to reflect what I suspect is the actual valid range
of 01..12 .
[13 Jan 2007 19:44] Paul DuBois 
The table that lists the format specifiers is followed by this
remark:

Ranges for the month and day specifiers begin with zero due to the fact
that MySQL allows the storing of incomplete dates such as '2004-00-00'.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html