Question

Sql server判断某一日期是在第几季度

有没有sql server 内置的函数？能不能更简单点的

Answer 1

DECLARE @month int
set @month=DATEPART(M,CONVERT(varchar(20),GETDATE(),112 ))
select @month as 当前月份,
CASE when @month between 1 and 3 then '第一季度'
when @month between 4 and 6 then '第二季度'
when @month between 7 and 9 then '第三季度'
else '第四季度'
end as 季度

Answer 2

Select Case when month(getdate()) in (1,2,3) then '春' when month(getdate()) in (4,5,6) then '厦' when month(getdate()) in (7,8,9) then '秋' when month(getdate()) in (10,11,12) then '冬' end

可以把你的时间放到getdate()那个位置去

Answer 3

SELECT DATEPART(quarter, '2017/08/25')
＝3

Answer 4

@m=datepart(m,时间)
@m>=1 && @m<=3 一季度
....

Answer 5

select '第' +convert(varchar,datename(qq,getdate()))+'季度'