如何计算2个指定时间的月份差额

Question

如何计算2个指定时间的月份差额如2000-02-1
到2008-5-3之间的月份差额?
谢谢.

Answer 1

select datediff(mm,'2000-02-1','2008-5-3')

Answer 2

declare @a datetime ,@b datetime
set @a='2000-02-1'
set @b='2008-5-3'
select datediff(mm,@a,@b)

Answer 3

select abs(month(convert(datetime,'2000-02-1'))-month(convert(datetime,'2008-5-3')))

Answer 4

select datediff(mm,'2008-02-1','2008-5-3')

Answer 5

DATEDIFF(MONTH,'2000-02-1','2008-5-3') ?

Answer 6

select (Year('2008-05-03') - Year('2000-02-1 ')) * 12 + (Month('2008-05-03') - Month('2000-02-1 '))

Answer 7

select datediff(m,'2000-02-1','2008-5-3')

Answer 8

select datediff(mm,'2000-02-1','2008-5-3')