用mysql的函数to_days()把日期转化成天数,再相减mysql> select to_days('2003-12-02');
+-----------------------+
| to_days('2003-12-02') |
+-----------------------+
|                731916 |
+-----------------------+
1 row in set (0.03 sec)mysql> select to_days('2003-12-05');
+-----------------------+
| to_days('2003-12-05') |
+-----------------------+
|                731919 |
+-----------------------+
1 row in set (0.00 sec)mysql>