https://dev.mysql.com/doc/refman/5.7...#function_date

Devi usare CURDATE()... DATE() fa un'altra cosa