Mysql中如何对按年月日查询时间字段

dao.find("select * from credit_item where prize_code= ? and year(create_time) = ? and month(create_time) = ? and day(create_time) = ?", code, new Date().getYear() + 1900, new Date().getMonth() + 1, new Date().getDate());