date_diff

date_diff介绍

date_diff(endDate, startDate) - 返回从 startDate 到 endDate 的天数差。

Examples:

> SELECT date_diff('2009-07-31', '2009-07-30');
 1
 
> SELECT date_diff('2009-07-30', '2009-07-31');
 -1

Since: 3.4.0