(fu)특장한 날짜로 부터 주차의 시작 날짜 가져오기

DATEADD(week, (datepart(week, getdate()) - datepart(week, study_start_date) ), DATEADD(DAY, @@@datefirst - DATEPART(weekday, CAST(YEAR(GETDATE()) AS VARCHAR) + '-01-01') - 6, CAST(YEAR(GETDATE()) AS VARCHAR) + '-01-01')),

DATEADD(week, (datepart(week, getdate()) - datepart(week, study_start_date) ), DATEADD(DAY, @@@datefirst - DATEPART(weekday, CAST(YEAR(GETDATE()) AS VARCHAR) + '-01-01') , CAST(YEAR(GETDATE()) AS VARCHAR) + '-01-01')),

2018년 1월 23일 화요일