[MSSQL] 지정 월 일자 가져오기(달력스타일, 전달/내달 일자 포함)

[MSSQL] 지정 월 일자 가져오기(달력스타일, 전달/내달 일자 포함)

DECLARE @wMONTH_S VARCHAR(10) = '2022-04' + '-01'; DECLARE @wMONTH_E VARCHAR(10) = DATEADD(DAY, -1, DATEADD(MONTH, 1, DATEADD(DAY, 1 - DAY(@wMONTH_S), @wMONTH_S))); DECLARE @wCALENDAR_S VARCHAR(10) = DATEADD(WK, 0, DATEADD(DAY, 1-DATEPART(WEEKDAY, @wMONTH_S), DATEDIFF(DD, 0, @wMONTH_S))); DECLARE @wCALENDAR_E VARCHAR(10) = DATEADD(WK, 1, DATEADD(DAY, 0-DATEPART(WEEKDAY, @wMONTH_E), DATEDIFF(DD, 0, @wMONTH_E))); WITH LISTDATES(ALLDATES) AS ( SELECT DATEADD(DAY,0,@wCALENDAR_S) AS DATE UNION ALL SELECT DATEADD(DAY,1,ALLDATES) FROM LISTDATES WHERE ALLDATES <= DATEADD(DAY,-1,@wCALENDAR_E)) SELECT ALLDATES FROM LISTDATES