Bug #47700 13 months
Submitted: 29 Sep 2009 7:18 Modified: 29 Oct 2009 7:37
Reporter: Szymon Sobczak Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[29 Sep 2009 7:18] Szymon Sobczak
In documentation of DATE_FORMAT function there are options:
%c 	Month, numeric (0..12)
%m 	Month, numeric (00..12)
Do we realy have 13 months in year?

How to repeat:
Just look here: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

Suggested fix:
Should be:
%c 	Month, numeric (1..12)
%m 	Month, numeric (01..12)
[29 Sep 2009 7:37] Valeriy Kravchuk
I think our manual just documents what we really have when accepting zeros in dates:

mysql> select date_format('2009-00-00', '%c %m');
| date_format('2009-00-00', '%c %m') |
| 0 00                               |
1 row in set (0.00 sec)

Why do you think this is a bug?
[30 Oct 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".