------------------------------------------------------------- @DelPeriod 10
SELECT @DelDayStr = '' SELECT @DelDay = DATEADD(day, -@DelPeriod, getdate())
SELECT @YEAR = DATEPART(year, @DelDay) SELECT @MONTH = DATEPART(month, @DelDay) SELECT @DAY = DATEPART(day, @DelDay)
SELECT @DelDayStr = Convert(char(4), DATEPART(year, @DelDay)) IF (@MONTH < 10) SELECT @DelDayStr = @DelDayStr + '0' + Convert(char(1), DATEPART(month, @DelDay)) ELSE SELECT @DelDayStr = @DelDayStr + Convert(char(2), DATEPART(month, @DelDay)) IF (@DAY < 10) SELECT @DelDayStr = @DelDayStr + '0' + Convert(char(1), DATEPART(day, @DelDay)) + '%' ELSE SELECT @DelDayStr = @DelDayStr + Convert(char(2), DATEPART(day, @DelDay)) + '%'
PRINT @DelDayStr
-----------------------------------------------------------------------------
프린트로 찍어보니 2004 밖에는 없더라구요..
@DelDayStr 변수에 값을 넣으려고 합니다.
sprintf 처럼 넣을 수 있는 방법 없나요?
|