At 11:03 PM +0200 5/29/1999, Quang D. Nguyen wrote:
>Dear MySQL Developers,
>
>How do you think about this problem?
>
>--cut here------
>mysql> create table example (
> -> mydate DATE );
>Query OK, 0 rows affected (0.02 sec)
>
>mysql> insert into example values ('1999-02-30');
>Query OK, 1 row affected (0.02 sec)
>
>mysql> select mydate from example
> -> ;
>+------------+
>| mydate |
>+------------+
>| 1999-02-30 |
>+------------+
>1 row in set (0.00 sec)
>
>mysql>
>---cut here----------------------
>
>Which day is 1999-02-30 ?
What result are you expecting?
--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/