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