select dateadd(week, datediff(week,0,CONVERT(DATETIME,GETDATE(),120)-1),0) SELECT CONVERT(Varchar(100),DATEADD(DAY, 6, DATEADD(wk, DATEDIFF(wk,0,getdate()),0)),120)
sql 获取本周周一和周日
原文：http://www.cnblogs.com/love-zf/p/5377282.html
