改正一下
declare @Now datetime,@Lday datetime,@Fday datetime
set @Now='2006-03-8'
select @Now=convert(datetime,(cast(Year(@Now) as varchar)+'-'+cast(month(@Now) as varchar)+'-01'),120)
set @Lday=dateadd(ss,-1,@Now)--最后一天
select @Lday
set @Fday=dateadd(mm,-1,@Now)--第一天
select @Fday
declare @Now datetime,@Lday datetime,@Fday datetime
set @Now='2006-03-01'
set @Lday=dateadd(ss,-1,@Now)--最后一天
select @Lday
set @Fday=dateadd(mm,-1,@Now)--第一天
select @Fday