datediff()怎么比较yyyyMM 类型之间相差的天数？

Question

如题

Answer 1

 select DATEDIFF(M,'20100101',GETDATE())

Answer 2

select DATEDIFF(M,'20100101',GETDATE())-----
10相差的天数用
select DATEDIFF(d,'20100101',GETDATE())-----
319

Answer 3

DATEDIFF(d,startDate,endDate)
如果只有年月時?

Answer 4

DECLARE @s1 NVARCHAR(10),@s2 NVARCHAR(10)
SELECT @s1='201008',@s2='201010'--這里轉為日期
SELECT @s1=@s1+'01'
,@s2=@s2+'01'SELECT DATEDIFF(m,@s1,@s2)

Answer 5

convert转换成日期
datadiff(month,exp1,exp2)

Answer 6

DECLARE @s1 NVARCHAR(10),@s2 NVARCHAR(10)
SELECT @s1='201008',@s2='201010'--這里轉為日期
SELECT    @s1=@s1+'01'
        ,@s2=@s2+'01'SELECT cast(right(@s2,2) as int)-cast(right(@s1,1)as int)