이번주 월요일~ 일요일 구하기
http://blog.naver.com/PostView.nhn?blogId=smart_guy&logNo=220393069177 SELECT DATEADD(wk, DATEDIFF(d, 0, getdate()) / 7 - 1, 0) AS '저번주 월요일' SELECT DATEADD(wk, DATEDIFF(d, 0, getdate()) / 7 - 1, 1) AS '저번주 화요일' SELECT DATEADD(wk, DATEDIFF(d, 0, getdate()) / 7 , 0) AS '저번주 월요일' SELECT DATEADD(wk, DATEDIFF(d, 0, getdate()) / 7 , 1) AS '저번주 화요일' WHERE __ BETWEEN DATEADD(wk, DATEDIFF(d, 0, getdate()..
2018. 5. 9.