Obtain the name of a week

Udf_WeekDayName
Copy codeThe Code is as follows:
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
Copy codeThe Code is as follows:
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