this was an interesting question to solve Hope this answer helps
Select left(datename(month,date_col),3)+'-'+right(datename(year,date_col),2) from table_name