mysql计算2个时间的时间差

 

 

TIMESTAMPDIFF(interval,datetime_expr1,datetime_expr2)  

 

interval参数的取值范围：

SECOND 秒 SECONDS 

MINUTE 分钟 MINUTES 

HOUR 时间 HOURS 

DAY 天 DAYS 

MONTH 月 MONTHS 

YEAR 年 YEARS

 

----------- 下面是官网文档的原文：

•  TIMESTAMPDIFF(unit,datetime_expr1,datetime_expr2)

  Returns datetime_expr2 − datetime_expr1, where datetime_expr1 and datetime_expr2 are date or datetime expressions. One expression may be a date and the other a datetime; a date value is treated as a datetime having the time part '00:00:00' where necessary. The unit for the result (an integer) is given by the unitargument. The legal values for unit are the same as those listed in the description of the TIMESTAMPADD()function.

  mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
          -> 3
  mysql> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01');
          -> -1
  mysql> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
          -> 128885
  

  Note

  The order of the date or datetime arguments for this function is the opposite of that used with the TIMESTAMP()function when invoked with 2 arguments.