SELECT LEFT(DATENAME(mm,Date1),3) + '-' + CAST(DATEPART(YEAR,Date1) AS VARCHAR) + ' - ' + LEFT(DATENAME(mm,Date2),3) + '-' + CAST(DATEPART(YEAR,Date2) AS VARCHAR),* FROM [YourTable]
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)