获取星期几的名称

两个自定义函数，一个是返回一个Table,另一个是直接返回名称

<br>CREATE FUNCTION [dbo].[udf_WeekDayName] <br>( <br>) <br>RETURNS @WeekDayName TABLE([Id] INT,[WeekDayName] NVARCHAR(15)) <br>AS <br>BEGIN <br>INSERT INTO @WeekDayName ([Id],[WeekDayName]) VALUES (0,'Saturday'),(1,'Sunday'),(2,'Monday'),(3,'Tuesday'),(4,'Wednesday'),(5,'Thursday'),(6,'Friday') <br>RETURN <br>END <br> <br>udf_WeekDayNameOfDate <br> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>CREATE FUNCTION [dbo].[udf_WeekDayNameOfDate] <br>( <br>@Date DATETIME <br>) <br>RETURNS NVARCHAR(10) <br>BEGIN <br>RETURN <br>CASE (DATEPART(dw, @Date) + @@DATEFIRST) % 7 <br>WHEN 0 THEN 'Saturday' <br>WHEN 1 THEN 'Sunday' <br>WHEN 2 THEN 'Monday' <br>WHEN 3 THEN 'Tuesday' <br>WHEN 4 THEN 'Wednesday' <br>WHEN 5 THEN 'Thursday' <br>WHEN 6 THEN 'Friday' <br>END <br>END                    </li></ol></pre>