Bug #47700 13 months

• Submitted: 29 Sep 2009 7:18
• Modified: 29 Oct 2009 7:37
• Reporter: Szymon Sobczak
• Status: No Feedback
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.1
• OS: Any
• CPU Architecture: Any

[29 Sep 2009 7:18] Szymon Sobczak

Description:
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".