MySql Date Function Issues

The format of a DATE value is 'YYYY-MM-DD'. According to standard SQL, no other format is permitted. You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example:

SELECT * FROM t1 WHERE date >= '2003-05-05';

http://dev.mysql.com/doc/refman/5.0/en/using-date.html