使用DATEDIFF來取得兩日期間的相差年、月、日

SELECT DATEDIFF(day, GETDATE(),'2011-10-01')

SELECT DATEDIFF(day, '2011-09-01','2011-10-01')

SELECT DATEDIFF(MONTH,'2011-09-01','2011-10-01')

SELECT DATEDIFF(MONTH,'20110915','20111001')

SELECT DATEDIFF(YEAR,'20010911','20111010')