MySQL DATEDIFF() 函数如何工作？
MySQL DATEDIFF() 函数返回两个日期之间的天数。该函数的语法如下 -
DATEDIFF(date1,date2)登录后复制
mysql> Select DATEDIFF('2017-10-22','2017-09-21') AS 'NUMBER OF DAYS'; +----------------+ | NUMBER OF DAYS | +----------------+ | 31 | +----------------+ 1 row in set (0.00 sec)登录后复制
