查询某一天的数据 select * from table WHERE to_days(create_date)=to_days( str_to_date('2016-11-25','%Y-%m-%d'))