本文介绍了一种使用SQL来确定特定季度开始月份的第一天，并计算该季度总天数的方法。通过定义变量并运用CASE WHEN语句及DATEADD和DATEDIFF函数实现了这一目标。
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)) as daysNum
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)) as daysNum
扫一扫
666
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
