본문 바로가기

DataBase/Ms Sql

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

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')),