At 3:31 PM -0700 8/16/99, Tupshin Harper wrote:
>The Mysql documentation(for both 3.22 and 3.23) have incorrect references to
>a DAY() function.
>
>http://www.mysql.com/Manual/manual.html#Date_and_time_functions
>
>The paragraph:
>"What if you want to know which animals have birthdays next month? For this
>type of calculation, year and day are irrelevant, you simply want to extract
>the month part of the birth column. MySQL provides several date-part
>extraction functions, such as YEAR(), MONTH() and DAY(). MONTH() is the
>appropriate function here. To see how it works, run a simple query that
>displays the value of both birth and MONTH(birth):"
>
>This strongly implies that DAY() performs as a day of month function. This
>is in fact incorrect since there is no DAY() function, and the correct
>function would be DAYOFMONTH(), or one of a few other functions depending on
>what info about the day you are looking for. I would highly recommend
>revising this paragraph(just replacing DAY with DAYOFMONTH would be
>sufficient). This one caused us quite a bit of confusion until we saw the
>it contradicted in other parts of the documentation.
Yow! Whatever made me think I could write documentation? :-)
Thanks for pointing out this error, I'll fix it.
--
Paul DuBois, paul@stripped
