日期函数

SELECT DATEDIFF('2017-11-29','2017-11-30') AS COL1

date1-date2 只计算天数 为-1

SELECT DATEDIFF('2017-11-30','2017-11-29') AS COL1

date1-date2 只计算天数 为1

edate为字段 查询明天的数据

select * from table1 where datediff(edate,now()) = 1;