List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 26 1999 11:53am
Subject:Re: y2k (another) bugs in MySQL
View as plain text  
At 12:34 PM +0200 5/26/1999, Fulajtar Pal wrote:
>No comment...........
>
>mysql> select DAYNAME('1999-02-31');
>+-----------------------+
>| DAYNAME('1999-02-31') |
>+-----------------------+
>| Wednesday             |
>+-----------------------+
>1 row in set (0.00 sec)

The answer you expect is ... what?

>mysql> select DAYNAME('2000-02-31');
>+-----------------------+
>| DAYNAME('2000-02-31') |
>+-----------------------+
>| Thursday              |
>+-----------------------+
>1 row in set (0.00 sec)

The answer you expect is ... what?

>mysql> select date_add('1998-02-31',Interval -1 day);
>+----------------------------------------+
>| date_add('1998-02-31',Interval -1 day) |
>+----------------------------------------+
>| 1998-03-02                             |
>+----------------------------------------+

The answer you expect is ... what?


I'm not trying to be cute above, but you're feeding in garbage.
What do you expect to get back, and why?

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
y2k (another) bugs in MySQLFulajtar Pal26 May
  • Re: y2k (another) bugs in MySQLThimble Smith26 May
  • Re: y2k (another) bugs in MySQLPaul DuBois26 May