获取星期几的名称
前端之家收集整理的这篇文章主要介绍了
获取星期几的名称,
前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
udfWeekDayName
<div class="codetitle">@L403_0@ 代码如下:
<div class="codebody" id="code73475">
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