Bug #5111 Wrong documentation on website
Submitted: 19 Aug 2004 18:06 Modified: 20 Sep 2004 14:27
Reporter: Kevin Patterson Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: CPU Architecture:Any

[19 Aug 2004 18:06] Kevin Patterson
Description:
In your online documentation for extract functions dealing with date you say that the user can use year/month/day(t) with t being a timestamp or date.  The day function does not work, however the dayofmonth(t) does.

How to repeat:
Try using the day(t) function with a database table that has a date column.

Suggested fix:
I wanted to suggest that you note this discrepancy in the documentation.  Perhaps, I'm running an outdated version?  This is not really a bug, but I couldn't find anywhere else to report this. So there you go.
[20 Aug 2004 0:42] Paul DuBois
We need a repeatable test case showing the
incorrect behavior.  I tried the following, which
yields the expected result:

mysql> desc date_val;
+-------+------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------+------+-----+---------+-------+
| d     | date | YES  |     | NULL    |       |
+-------+------+------+-----+---------+-------+
1 row in set (0.16 sec)

mysql> select d,day(d) from date_val;
+------------+--------+
| d          | day(d) |
+------------+--------+
| 1864-02-28 |     28 |
| 1900-01-15 |     15 |
| 1987-03-05 |      5 |
| 1999-12-31 |     31 |
| 2000-06-04 |      4 |
+------------+--------+
5 rows in set (0.32 sec)
[20 Aug 2004 14:27] Kevin Patterson
Well, it looks like it works for you.  I guess I'm running an older version.  I couldn't figure out how to find out what version I'm running, so I can't really tell if that's the problem.  Anyways, thanks for the help and sorry I misreported that documentation.
[14 Feb 2005 22:54] 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".