获取星期几的名称

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