今日同时想找个英文版的获取当日对应的星期,于是自己写了一个函数如下:
---
Create Function dbo.GetDayName
( @datetime varchar(120)
)
returns nvarchar(20)
as
begin
Declare @dateWeekName varchar(20);
Declare @WLJ varchar(20)
select @dateWeekName=a, @WLJ=Convert(datetime,getdate(),11)
from(select a='Monday',b=1
union all select 'Tuesday',2 union all select 'Wednesday',3
union all select 'Thursday',4 union all select 'Friday',5
union all select 'Saturday',6 union all select 'Sunday',0
)a where b = (datepart(weekday,getdate())-1)
--select @dateWeekName,@WLJ
return @dateWeekName
end