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/
