SQL - DATEADD

来源:互联网 发布:淘宝信誉评级怎么看 编辑:程序博客网 时间:2024/05/21 07:53

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)

原创粉丝点击