SQL Server with Cognos Year, Month, Day convertion

SQL Server with Cognos Year, Month, Day conversion

Year
convert(Char(4),Year(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))


Month

case when convert(Char(2),Month(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))<10 then
'0'||convert(Char(2),Month(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))
else convert(Char(2),Month(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))
end

Day

convert(Char(8),Day(CAST ( [Audit].[Run Reports].[Time stamp] AS Date )))