Same here. Got 0's for the invalid dates, correct date for the other. What is wrong?
Adam Clauss [EMAIL PROTECTED] > -----Original Message----- > From: Rajesh Kumar [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 1:35 PM > To: Hans van Harten > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL running out of date > > > Hans van Harten unknowingly asked us: > > 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. > > -- > [ Rajesh Kumar ] > __________________________________________ > Meet the guy at http://www.meetRajesh.com/ > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]