摘要： 1 DECLARE @date DATETIME = GETDATE() 2 SELECT 3 CONVERT(VARCHAR(10),DATEADD(DAY,-6-DATEPART(WEEKDAY,@date),@date),121) AS [上周日], 4 CONVERT(VARCHAR(10),DATEADD(DAY,1-DATEPART(WEEKDAY,@date),@date),... 阅读全文