差幾天

SELECT DATEDIFF('2007-12-31 23:59:59','2007-12-30');+----------------------------------------------+| DATEDIFF('2007-12-31 23:59:59','2007-12-30') |+----------------------------------------------+| 1 |+----------------------------------------------+SELECT DATEDIFF('2010-11-30 23:59:59','2010-12-31');+----------------------------------------------+| DATEDIFF('2010-11-30 23:59:59','2010-12-31') |+----------------------------------------------+| -31 |+----------------------------------------------+