declare @bdate datetime,@edate datetime,@date datetime
set @date='2007-4-1'
set @bdate=cast(convert(char(7),@date,120)+'-1' as datetime)
set @edate=dateadd(mm,1,@bdate)
select datediff(d,@bdate,@edate)
set @date='2007-4-1'
set @bdate=cast(convert(char(7),@date,120)+'-1' as datetime)
set @edate=dateadd(mm,1,@bdate)
select datediff(d,@bdate,@edate)