Mysql自带的年月日函数

 

SELECT * from meeting
where year(time)=year('2018-10-18') and month(time)=month('2018-10-18') and day(time)=day('2018-10-18')