Dynamically generate SQL Server backup date/time format


	Select CONVERT(Varchar(4), DATEPART(yy, getDate())) +
	CASE WHEN LEN(DATEPART(mm, getDate())) = 1
	THEN '0' + CONVERT(Varchar(2),DATEPART(mm, getDate()))
	ELSE CONVERT(Varchar(2),DATEPART(mm, getDate())) END
	+
	CASE WHEN LEN(DATEPART(dd, getDate())) = 1
	THEN '0' + CONVERT(Varchar(2),DATEPART(dd, getDate()))
	ELSE CONVERT(Varchar(2),DATEPART(dd, getDate())) END