mysqlDATETIME 类型的字段作为查询条件的sql

mysql DATETIME 类型的字段作为查询条件的sql

SELECT*
FROMpro_team_plan AS a
WHEREa.birthtime BETWEEN STR_TO_DATE('2018-03-12','%Y-%m-%d %H')
AND STR_TO_DATE('2018-04-17','%Y-%m-%d %H'
)