■ DATETIME 값을 'yyyyMMdd' 문자열로 변환하는 방법을 보여준다.
▶ 예제 코드 (SQL)
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
CREATE FUNCTION dbo.GetPackedDate ( @Date DATETIME ) RETURNS NVARCHAR(8) AS BEGIN DECLARE @PackedDate NVARCHAR(8); DECLARE @Year NVARCHAR(4); DECLARE @Month NVARCHAR(2); DECLARE @Day NVARCHAR(2); SET @Year = CONVERT(NVARCHAR(4), YEAR (@Date)); SET @Month = CONVERT(NVARCHAR(2), Month(@Date)); SET @Day = CONVERT(NVARCHAR(2), Day (@Date)); SET @Month = SUBSTRING('0' + @Month, LEN(@Month), 2); SET @Day = SUBSTRING('0' + @Day , LEN(@Day ), 2); SET @PackedDate = @Year + @Month + @Day; RETURN @PackedDate; END |