sql server 求以日期所在周的第一天（星期一）和最后一天（星期日）函数

最新推荐文章于 2024-01-11 17:06:31 发布

hm446434459

最新推荐文章于 2024-01-11 17:06:31 发布

阅读量1.7k

点赞数

分类专栏： sql 文章标签： sql server function join

本文链接：https://blog.csdn.net/hm446434459/article/details/7397779

版权

sql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

SET ANSI_NULLS ON

GO
SET QUOTED_IDENTIFIER ON
GO
create FUNCTION [dbo].[dm_OneDay_GetWeekFirstAndEndDay](@tmpDate DATETIME)
RETURNS varchar(200)
AS
BEGIN
declare @first2endDay varchar(200)

    SELECT @first2endDay = a.FirstDay+'~'+b.EndDay FROM (
        SELECT 1 AS ID, case when datepart(weekday,@tmpDate)=1 then   convert(varchar(100),dateadd(dd,-6,@tmpDate),23) else convert(varchar(100),DATEADD(wk, DATEDIFF(wk,0,@tmpDate), 0),23) end AS FirstDAy
    ) a
    LEFT JOIN (
        SELECT 1 AS ID,case when datepart(weekday,@tmpDate) =1 then   convert(varchar(100),@tmpDate,23) else convert(varchar(100),DATEADD(wk, DATEDIFF(wk,0,@tmpDate), 6),23) end AS EndDay
    ) b
    ON a.ID = b.ID
    RETURN @first2endDay
END