求一SQL查询语句！求两时间段之间的月份差值！

[hmq1012]

比如一个表中间有两个时间的字段，date1(2011-6-1)和date2(2010-6-1)，那样的话查询出来的月份差就是12，那请问这样的查询语句如何写呢？

[--小F--]

select datediff(mm,date1,date2) from tb 

[javatemptation]

select DATEDIFF(M,'2010-06-01','2011-06-01');

[-晴天]

select datediff(m,'2010-6-1','2011-6-1')
/*
-----------
12

(1 行受影响)

*/(

[叶子]

select datediff([month],date1,date2)

[AcHerat]

-- day
select .. from tb where date between @date1 and @date2


-- month
select .. from tb where convert(varchar(7),date,120) between convert(varchar(7),@date1,120) and convert(varchar(7),@date2,120)

[AcHerat]

select datediff(mm,@date1,@date2)

[Scofield_jieyitong]

select * from [table_name]where datediff(m,'2010.6.1','2011.6.1')=12

[叶子]

declare @table table(date1 datetime,date2 datetime)
insert into @table
select '2011-6-1','2010-6-1'

select abs(datediff(month,date1,date2)) from @table
/*
12
*/

[hgqiang_304]

简单计算：
差额=(year(d1)-year(d2))*12+month(d1)-month(d2)