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

fullmi(49)
Published in
#it
Words
48
Reading
1 min
9y
Listen to this post
~1 min

DATEADD(week, (datepart(week, getdate()) - datepart(week, study_start_date) ), DATEADD(DAY, @@datefirst@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@datefirst - DATEPART(weekday, CAST(YEAR(GETDATE()) AS VARCHAR) + '-01-01') , CAST(YEAR(GETDATE()) AS VARCHAR) + '-01-01')),


2018년 1월 23일 화요일
developer
2
(fu)특장한 날짜로 부터 주차의 시작 날짜 가져오기 | Ecency