List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 17 1999 3:49pm
Subject:Re: Documentation bug "Day()"
View as plain text  
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.
>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
Problem with Perl and MySQLDeniz Demir16 Aug
RE: Problem with Perl and MySQLerling.molde17 Aug
  • Documentation bug "Day()"Tupshin Harper17 Aug
    • Re: Documentation bug "Day()"Paul DuBois17 Aug
    • Re: Documentation bug "Day()"Aleksandar Ivanisevic20 Aug
      • Re: Documentation bug "Day()"Michael Widenius22 Aug
    • non unique keys in heap tablesAleksandar Ivanisevic22 Aug