[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(ch..
더보기