List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 30 1999 12:44pm
Subject:Re: stoopid date acceptance
View as plain text  
At 1:55 PM +0200 1999/11/30, Florin Andrei wrote:
>	Hey, watch this:
>
>===========================================================
>mysql> create table test (data date);
>Query OK, 0 rows affected (0.01 sec)
>
>mysql> insert into test values ('1999-02-31');
>Query OK, 1 row affected (0.00 sec)
>
>mysql> select * from test;
>+------------+
>| data       |
>+------------+
>| 1999-02-31 |
>+------------+
>1 row in set (0.00 sec)
>
>mysql> select version();                    
>+-------------+
>| version()   |
>+-------------+
>| 3.22.25-log |
>+-------------+
>1 row in set (0.00 sec)
>
>mysql>
>===========================================================
>
>	1999-02-31 ?????????????????? :-) I thought this one cannot exist...


Then don't insert non-existent dates into your table.
That is, verify your dates first.

-- 
Paul DuBois, paul@stripped
Thread
stoopid date acceptanceFlorin Andrei30 Nov
  • Re: stoopid date acceptancePaul DuBois30 Nov
  • Re: stoopid date acceptanceFlorin Andrei30 Nov
  • Re: stoopid date acceptanceFlorin Andrei30 Nov
    • Re: stoopid date acceptanceVivek Khera30 Nov
      • Re: stoopid date acceptanceMatthias Urlichs30 Nov
        • Re: stoopid date acceptancePaul DuBois7 Dec
    • Re: stoopid date acceptancePaul DuBois7 Dec
  • Re: stoopid date acceptanceSasha Pachev8 Dec
  • Re: stoopid date acceptanceTonu Samuel8 Dec