select CONVERT(NVARCHAR(8), DATEADD(week, DATEDIFF(week, '', GETDATE()), ''), 112)
select CONVERT(NVARCHAR(8), DATEADD(week, DATEDIFF(week, '', GETDATE()), -7), 112)
select CONVERT(NVARCHAR(8), DATEADD(week, DATEDIFF(week, '', GETDATE()), -7*2), 112)
SQL - DATEADD
最新推荐文章于 2024-09-15 23:28:35 发布