List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:May 26 1999 10:46am
Subject:Re: y2k (another) bugs in MySQL
View as plain text  
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.
>
Thread
y2k (another) bugs in MySQLFulajtar Pal26 May
  • Re: y2k (another) bugs in MySQLThimble Smith26 May
  • Re: y2k (another) bugs in MySQLPaul DuBois26 May