As per the manual that is correct.
The only correct date will be 1996-02-31.
what is the problem?

-----Original Message-----
From: Hans van Harten [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 4:09 PM
To: [EMAIL PROTECTED]
Subject: MySQL running out of date 


Some make the laughing stock of MySQL with this code:
    create database data_test ;
    use data_test;
    create table test3 (a date);
    insert into test3 values (-1);
    insert into test3 values ('1996-02-31');
    insert into test3 values ('1996-67-31');
    select * from test3;

I ran it on MYSQL-4.10-max and was not amused.
Anyone to comment??

HansH

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to