100函数呢?
引用手册的页面:
DATEDIFF()返回expr1–expr2
mysql> select datediff('2010-04-15', '2010-04-12');
+--------------------------------------+
| datediff('2010-04-15', '2010-04-12') |
+--------------------------------------+
| 3 |
+--------------------------------------+
1 row in set (0,00 sec)
但是请注意,日期应该写为YYYY-MM-DD
,而不是像你发布的那样写为DD-MM-YYYY
.