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
