SQL Query : Date in DD MMM YYYY format example

Today i got a requirement to convert my date into day month and year format. I have used below query for that.
This kind of format mainly we are going to use in the PIVOT Queries as well as dynamics queries of SQL Server.

declare @date date
set @date=GETDATE()
print (cast(day(@date) as varchar))+' '+convert(char(3), @date, 0)+ ' '+       
cast(year(@date) as varchar)        

Output of the

18 Dec 2012