Mysql日期差函数（以及日期差作为条件语句）

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；