SQL Server convert date to String MMMYYDD

Question

Im trying to convert date value into this MMMYYDD String format, using native Sql server 2008 r2 function,

I checked here http://www.sql-server-helper.com/tips/date-formats.aspx

and still I can't find matching format.

any ideas?

Answer 1

something like this?

select convert(varchar(3), @date, 7) + convert(varchar(4), @date, 12)

sql fiddle demo