declare @one datetime
declare @two datetime
--本月第一天
set @one = dateadd(day,-day('2015-02-01')+1,'2015-02-01')
--上个月第一天
set @two = dateadd(month,1,@one)
declare @two datetime
--本月第一天
set @one = dateadd(day,-day('2015-02-01')+1,'2015-02-01')
--上个月第一天
set @two = dateadd(month,1,@one)
select datediff(day,@one,@two) as ThisMonth
//思路:下个月(一号)减去当前月(一号)的差,就是天数