SELECT * from table where TIMESTAMPDIFF(DAY,pretime,latertime)>=1

TIMESTAMPDIFF通过时分秒相比来计算日期差

TIMESTAMPDIFF函数，需要三个参数，type是比较的类型，可以比较FRAC_SECOND、SECOND、 MINUTE、 HOUR、 DAY、 WEEK、 MONTH、 QUARTER或 YEAR几种类型

select timestampdiff(DAY,"2018-08-22 15:15:16","2018-08-23 15:15:16") as timestamodiff; // 结果 1 想差一天 select timestampdiff(DAY,"2018-08-22 15:15:19","2018-08-23 15:15:16") as timestamodiff; // 结果 0 想差不到一天 select timestampdiff(DAY,"2018-08-23 15:15:19","2018-08-22 15:15:16") as timestamodiff; // 结果 -1 想差一天 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT * from table where DATEDIFF(pretime,latertime)>=1

DATEDIFF不比较时分秒

SELECT DATEDIFF('2018-05-09 00:00:00','2018-05-09 23:59:59') AS DiffDate;  //结果 0 ；  SELECT DATEDIFF('2018-05-08 23:59:59','2018-05-09 00:00:00') AS DiffDate;  //结果 -1；  SELECT DATEDIFF('2018-05-09 00:00:00','2018-05-08 23:59:59') AS DiffDate; //结果 1；