Cacher is the code snippet organizer for pro developers

Select right('0000' + cast(datepart(year, '2015-02-10 09:56:22') as varchar(4)), 4) + right('00' + cast(datepart(month, '2015-02-10 09:56:22') as varchar(2)), 2)