padding dateparts with zeros

So I take in a date '2012-02-01 12:30:00.000' and I need to turn it into a string, ohhh excuse me, varchar.

'20120201'

What to do? Padding with zeros.



declare @date datetime
set @date = getdate()
SELECT convert(varchar,DATEPART(YYYY,@date)) + right(N'0' + convert(varchar,month(@date)), 2) + right(N'0' + datename(d, @date), 2)


declare @now datetime
set @now = getDate()
select datename(yyyy, @now) as year
, right(N'0' + convert(nvarchar(2), month(@now)), 2) as month
, right(N'0' + datename(d, @now), 2) as day
, right(N'0' + datename(hh, @now), 2) as hour
, right(N'0' + datename(n, @now), 2) as minute
, right(N'0' + datename(s, @now), 2) as second

thanks to the good folks at dzone.

http://snippets.dzone.com/posts/show/6379