sql一周时间段（周一起始）

select   DATEADD ( Day ,  1 - case   DATEPART (Weekday, CONVERT ( varchar ( 10 ),  GETDATE (),  120 ))  when    1   then   7   else   DATEPART (Weekday, CONVERT ( varchar ( 10 ),  GETDATE (),  120 )) - 1   end , CONVERT ( varchar ( 10 ),  GETDATE () - 7 ,  120 ))
as  startTime
select   DATEADD ( Day ,  1 - case   DATEPART (Weekday, CONVERT ( varchar ( 10 ),  GETDATE (),  120 ))  when    1   then   7   else   DATEPART (Weekday, CONVERT ( varchar ( 10 ),  GETDATE (),  120 )) - 1   end ,  CONVERT ( varchar ( 10 ),  GETDATE (),  120 ))
as  endTime

转载于:https://www.cnblogs.com/lishenglyx/archive/2009/07/20/1526874.html