[MS-SQL] 다음달 (1일 기준으로) 구하기.

DECLARE @now smalldatetime = GETDATE();
SELECT @now, 
CAST(CONVERT(varchar(8), DATEADD(mm, 1, DATEADD(DAY, 1-DAY(@now), @now)), 112) AS int)





-------------------------------------------

 

DECLARE @now smalldatetime = GETDATE();
DECLARE @now2 smalldatetime;
SET @now2 = CONVERT(varchar(8), DATEADD(mm, 1, DATEADD(DAY, 1-DAY(@now), @now)), 112);
SELECT @now, @now2