Adam Clauss and Rajesh Kumar wrote:
>> Hans van Harten unknowingly asked us:
LOL
>>> 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??
>> Yeah, what's wrong with this? Absolutely expected results.
> Same here.
> Got 0's for the invalid dates, correct date for the other. What is
> wrong?
I'ld say, NONE of them is correct ... Februari _31_st !!
Then I'ld expect at least a warning, rather an error, on each of the
samples!
HansH
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
