Best way to format date in nvarchar
I need date format like "2011 Oct 24" in SQL 2008 and there is no any inbuilt format in convert function to get this. I got some ways to achieve this. Can anybody please guide me which are best way to get it in terms of execution and performance ? 

Following are 2 ways to get it :

    1) select  substring(convert(varchar(20),getdate(),106),8,4) + ' ' + 
            substring(convert(varchar(20),getdate(),106),4,3) + ' ' + 
            substring(convert(varchar(20),getdate(),106),1,3) 
    
    2) SELECT DATENAME(YYYY,GETDATE()) + ' ' + CAST(DATENAME(MM,GETDATE()) AS VARCHAR(3)) + ' ' + DATENAME(DD,GETDATE())


Best way to format date in nvarchar
===

I need date format like "2011 Oct 24" in SQL 2008 and there is no any inbuilt format in convert function to get this. I got some ways to achieve this. Can anybody please guide me which are best way to get it in terms of execution and performance ? 

Following are 2 ways to get it :

    1) select  substring(convert(varchar(20),getdate(),106),8,4) + ' ' + 
            substring(convert(varchar(20),getdate(),106),4,3) + ' ' + 
            substring(convert(varchar(20),getdate(),106),1,3) 
    
    2) SELECT DATENAME(YYYY,GETDATE()) + ' ' + CAST(DATENAME(MM,GETDATE()) AS VARCHAR(3)) + ' ' + DATENAME(DD,GETDATE())

