DATEDIFF() 函数返回两个日期之间的天数。 例如: SELECT DATEDIFF(day,'2008-12-30','2008-12-29') AS DiffDate 结果: DiffDate -1