SQL Query Date in MMM DD YYYY format example

declare @date date

set @date=GETDATE()

print (convert(char(3), @date, 0)+ ' '+ (cast(day(@date) as varchar))+' '+     

cast(year(@date) as varchar))