WeekDay TO DateTime
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate()))) ),23) as 下周一
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+1),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+2),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+3),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+4),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+5),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+6),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+1),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+2),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+3),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+4),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+5),23)
SELECT CONVERT(VARCHAR, (DATEADD(week, 1, getdate())-(DATEPART(DW, DATEADD(week, 1, getdate())))+6),23)
