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 ?
>
MySQL does not take responsibility for input to a date field. It does
minimal limit checks. It's up to the user's app to impose stricter
limitations.
jim...
