데이터베이스/MSSQL
이번주 월요일~ 일요일 구하기
죠부니
2018. 5. 9. 11:32
반응형
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()) / 7 , 0) and DATEADD(wk, DATEDIFF(d, 0, getdate()) / 7 , 6)
반응형