SELECT DATENAME(yy,GETDATE()) --当前年
SELECT DATENAME(mm,GETDATE()) --当前月
SELECT DATENAME(dd,GETDATE()) --当前号
SELECT DATENAME(week,GETDATE()) --当前年的多少周
SELECT DATENAME (dw, GETDATE()) --星期几
SELECT '第' + CAST(DATENAME (quarter, GETDATE()) as varchar(1)) +'季度'--季度
--T_Calendar 已近创建好的表,取自己需要的字段
DECLARE @EndDate as smalldatetime
set @EndDate='2020-01-01'
while @EndDate <='2020-12-31'
begin
insert into T_Calendar(DeptID,DeptName,ShiftDate,WorkDay,WeekDayNum,WorkType)
values('301802','IQC实验室',convert(nvarchar(10),@EndDate,120),1,DATENAME (dw, @EndDate),'工作日')
set @EndDate= @EndDate+1
end