These have been discussed in the past. They're not Y2K bugs,
they're just ... hard to handle in "the way one would expect."
Probably because it's not clear what one would expect. If you
have a good idea of what the de facto standard is (i.e., what
"all the other databases" do), your input would be appreciated.
The mailing list has several threads related to this stuff. I
think if you search for DATEADD you'll find it.
Tim
On 26-May-1999 12:34, y2k (another) bugs in MySQL wrote:
>No comment...........
>
>mysql> select DAYNAME('1999-02-31');
>+-----------------------+
>| DAYNAME('1999-02-31') |
>+-----------------------+
>| Wednesday |
>+-----------------------+
>1 row in set (0.00 sec)
>
>mysql> select DAYNAME('2000-02-31');
>+-----------------------+
>| DAYNAME('2000-02-31') |
>+-----------------------+
>| Thursday |
>+-----------------------+
>1 row in set (0.00 sec)
>
>
>mysql> select date_add('1998-02-31',Interval -1 day);
>+----------------------------------------+
>| date_add('1998-02-31',Interval -1 day) |
>+----------------------------------------+
>| 1998-03-02 |
>+----------------------------------------+
>
>
>
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail mysql-thread3942@stripped
>
>To unsubscribe, send a message to the address shown in the
>List-Unsubscribe header of this message. If you cannot see it,
>e-mail mysql-unsubscribe@stripped instead.
>
