DATEDIFF() 函数返回两个日期之间的天数
语法:DATEDIFF(date1,date2)
eg:
SELECT DATEDIFF('2008-12-30','2008-12-29') AS DiffDate 结果:1
SELECT DATEDIFF('2008-12-29','2008-12-30') AS DiffDate 结果:-1
DATEDIFF() 函数返回两个日期之间的天数
语法:DATEDIFF(date1,date2)
eg:
SELECT DATEDIFF('2008-12-30','2008-12-29') AS DiffDate 结果:1
SELECT DATEDIFF('2008-12-29','2008-12-30') AS DiffDate 结果:-1