效果:
declare @beginDate date;
set @beginDate=getdate();
select
convert(varchar(10),@beginDate,112) as datekey,
year(@beginDate) as NIAN,
datepart(quarter,@beginDate) as JIDU,
case
when datepart(quarter,@beginDate)=1 then '第一季度'
when datepart(quarter,@beginDate)=2 then '第二季度'
when datepart(quarter,@beginDate)=3 then '第三季度'
else '