描述:开始:2010-09 结束:2011-07
解决方法:
set @diffmonths=datediff(month,cast((@DateBegin+'-01') as datetime),cast((@DateEnd+'-01') as datetime))+1
set @DateTest=cast((@DateBegin+'-01') as datetime)
select @diffmonths,@DateBegin,cast(@DateBegin+'-01' as datetime),cast(@DateEnd+'-01' as datetime)
分隔出:年 月
set @Years=year(@DateTest)
set @Months=case len(Cast(month(@DateTest) as varchar)) when 1 then '0' else '' end+Cast(month(@DateTest) as varchar);--补全2位
set @DateTest=dateadd(mm,1,@DateTest)
select @Years,@Months,@DateTest