SQL SERVER 获取本周周日和下周周日

下周周日

SELECT DATEADD(DAY, 6, DATEADD(WEEK, DATEDIFF(WEEK, 0, CONVERT(DATETIME, GETDATE(), 120) ), 0));

本周周日

SELECT dateadd(day , -1, DATEADD(wk, DATEDIFF(wk, 0, GETDATE()), 0))

获取逻辑是 先获取周第一天,然后进行加减

Leave a Reply

Your email address will not be published. Required fields are marked *