1.可以更改语言设置 SET LANGUAGE us_english2.也可以通过datepart(weekday,getdate()),然后用case when
select case when datepart(weekday,getdate()) = 1 then 'SUN' when datepart(weekday,getdate()) = 2 then 'MON' when datepart(weekday,getdate()) = 3 then 'TUE' when datepart(weekday,getdate()) = 4 then 'WED' when datepart(weekday,getdate()) = 5 then 'THU' when datepart(weekday,getdate()) = 6 then 'FRI' when datepart(weekday,getdate()) = 7 then 'SAT' end
SET LANGUAGE us_english2.也可以通过datepart(weekday,getdate()),然后用case when
when datepart(weekday,getdate()) = 2 then 'MON'
when datepart(weekday,getdate()) = 3 then 'TUE'
when datepart(weekday,getdate()) = 4 then 'WED'
when datepart(weekday,getdate()) = 5 then 'THU'
when datepart(weekday,getdate()) = 6 then 'FRI'
when datepart(weekday,getdate()) = 7 then 'SAT'
end