declare @date1 varchar(10),@date2 varchar(10)
set @date1='2013-10-20'
set @date2='2013-10-21'
select mon=
(case when Day(@date2) > DAY(@date1) then datediff(month,@date1,@date2) + 1
else datediff(month,@date1,@date2)
end)
select convert(char(10),DATEADD(dy,-1,@date1),120)
set @date1='2013-10-20'
set @date2='2013-10-21'
select mon=
(case when Day(@date2) > DAY(@date1) then datediff(month,@date1,@date2) + 1
else datediff(month,@date1,@date2)
end)
select convert(char(10),DATEADD(dy,-1,@date1),120)