Not the most efficient solution....

DECLARE @currentTime DATETIME

SET @currentTime = GETDATE()

SELECT CAST(DATEPART(year,@currentTime) AS CHAR(4))

+ CASE WHEN (DATEPART(month,@currentTime)) > 10 then (CAST(DATEPART(month,@currentTime) AS CHAR(2)))

ELSE '0' + CAST(DATEPART(month,@currentTime) AS CHAR(1)) END

+ CASE WHEN (DATEPART(day,@currentTime)) > 10 THEN (CAST(DATEPART(day,@currentTime) AS CHAR(2)))

ELSE '0' + CAST(DATEPART(day,@currentTime) AS CHAR(1)) END

+ CASE WHEN (DATEPART(hour,@currentTime)) > 10 THEN (CAST(DATEPART(hour,@currentTime) AS CHAR(2)))

ELSE '0' + CAST(DATEPART(hour,@currentTime) AS CHAR(1)) END

+ CASE WHEN (DATEPART(minute,@currentTime)) > 10 THEN (CAST(DATEPART(minute,@currentTime) AS CHAR(2)))

ELSE '0' + CAST(DATEPART(minute,@currentTime) AS CHAR(1)) END