获取2017-06-14 17:33:03到现在的所有订单 方法一: SELECT createTime from t_schedule_orders where DATEDIFF(createTime ,’2017-06-14 17:33:03’) >=0 and DATEDIFF(createTime,NOW()) <=0
方法二: SELECT createTime from t_schedule_orders where createTime>=’2017-06-14 17:33:03’
解读函数: 在mysql中函数DATEDIFF(a,b)的意思是: a-b的天数
select DATEDIFF(‘2017-06-14’,’2017-06-13’) AS 天数; 结果是1天 select DATEDIFF(‘2017-06-13’,’2017-06-14’) AS 天数; 结果是-1天
