DATEADD(mm, DATEDIFF(m,0,getdate())+1, 0)))
4）判断是否闰年：
SELECT case day(dateadd(mm, 2, dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)))) when 28 then ''''平年'''' else ''''闰年'''' end
或者
select case datediff(day,datename(year,getdate())+''''-02-01'''',dateadd(mm,1,datename(year,getdate())+''''-02-01''''))
when 28 then ''''平年'''' else ''''闰年'''' end
5）一个季度多少天
declare @m tinyint,@time smalldatetime
select @m=month(getdate())
select @m=case when @m between 1 and 3 then 1
when @m between 4 and 6 then 4
when @m between 7 and 9 then 7
else 10 end
select @time=datename(year,getdate())+''''-''''+convert(varchar(10),@m)+''''-01''''
select datediff(day,@time,dateadd(mm,3,@time))
上一页 [1] [2] |
