获取星期几的名称

284 阅读 0 评论 188 点赞

我是靠谱客的博主清秀机器猫，这篇文章主要介绍获取星期几的名称，现在分享给大家，希望可以做个参考。

udf_WeekDayName

复制代码代码如下:

 
CREATE FUNCTION [dbo].[udf_WeekDayName] 
( 
) 
RETURNS @WeekDayName TABLE([Id] INT,[WeekDayName] NVARCHAR(15)) 
AS 
BEGIN 
INSERT INTO @WeekDayName ([Id],[WeekDayName]) VALUES (0,'Saturday'),(1,'Sunday'),(2,'Monday'),(3,'Tuesday'),(4,'Wednesday'),(5,'Thursday'),(6,'Friday') 
RETURN 
END 

udf_WeekDayNameOfDate

复制代码代码如下:

 
CREATE FUNCTION [dbo].[udf_WeekDayNameOfDate] 
( 
@Date DATETIME 
) 
RETURNS NVARCHAR(10) 
BEGIN 
RETURN 
CASE (DATEPART(dw, @Date) + @@DATEFIRST) % 7 
WHEN 0 THEN 'Saturday' 
WHEN 1 THEN 'Sunday' 
WHEN 2 THEN 'Monday' 
WHEN 3 THEN 'Tuesday' 
WHEN 4 THEN 'Wednesday' 
WHEN 5 THEN 'Thursday' 
WHEN 6 THEN 'Friday' 
END 
END 