List:General Discussion« Previous MessageNext Message »
From:Jim Faucette Date:May 29 1999 9:14pm
Subject:Re: How is it?
View as plain text  
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...
Thread
How is it?Quang D. Nguyen30 May
  • Re: How is it?Jim Faucette30 May
  • Re: How is it?Paul DuBois30 May
    • Re: How is it?Quang D. Nguyen30 May
      • Re: How is it?Jim Faucette30 May
        • Re: How is it?Quang D. Nguyen30 May
          • Re: How is it?Sasha Pachev30 May
        • Re: How is it?Michael Widenius3 Jun