年份条件工作正常，但我运行年份和日期显示为null

SELECT Sum(gross_motor + visual_motor_skills 
       + draws_a_person + prints_personal_data) 
FROM   brigance_screening_term0 AS T0 
WHERE  year = 2011 
   AND Str_to_date(date, '%Y-%m-%d') = 2016 - 05 - 11 
LIMIT  1 

1 个解决方案

#1

seem you have a typo

好像你有一个错字

 AND Str_to_date(date, '%Y-%m-%d') = 2016 - 05 - 11  

should be

应该

 AND Str_to_date(date, '%Y-%m-%d') = '2016-05-11'