[DB] 주간 시작월요일 + 종료일요일, 시작일요일 + 종료토요일 구하기

Declare @dt DateTime

Set @dt = '2010-01-04'

   select

     [TargetDay] = convert(char(10), @dt, 120),

     [Start_Monday] = convert(char(10) , dateadd(dd, 1 - (datepart(weekday, @dt-1)), @dt), 120),

     [End_Sunday] = convert(char(10) , dateadd(dd, (7 - datepart(weekday, @dt-1)), @dt), 120),

     [Start_Sunday] = convert(char(10) , dateadd(dd, -1 * (datepart(weekday, @dt) - 1), @dt), 120),

     [End_Saturday] = convert(char(10) , dateadd(dd, (7 - datepart(weekday, @dt)), @dt), 120)