declare @iDays int
declare @dt varchar(50)
set @dt='2009-07-01'
select @iDays=day(dateadd(d,-Day(dateadd(m,1,convert(datetime,@dt))),dateadd(m,1,convert(datetime,@dt))))
print @iDays
declare @iDays int
declare @dt varchar(50)
set @dt='2009-07-01'
select @iDays=day(dateadd(d,-Day(dateadd(m,1,convert(datetime,@dt))),dateadd(m,1,convert(datetime,@dt))))
print @iDays
转载于:https://www.cnblogs.com/Donkey/archive/2010/07/25/1784697.html