mysql------1.查询当天的所有数据

select xs.* from xn_supervision xs where  xs.task_type="+taskType+"  and  xs.create_time>date(now()) and xs.create_time<DATE_ADD(date(NOW()),INTERVAL 1 DAY);