tako2013提到:
select dateadd(d,7-datepart(w,getdate())-0,getdate())
<pre class="c" name="code">select convert(varchar(10),dateadd(d,7-datepart(w,getdate())-0,getdate()),120)
<pre class="c" name="code">Select CONVERT(Date, DATEADD(D, 7-datepart(w,getdate()),getdate()))