select substring(CONVERT(VARCHAR(12), COLUMNNAME, 106),3,10) AS date from YOURTABLE
select convert(nvarchar(max),getdate(),106)
select substring(convert(nvarchar(max),getdate(),106),3,100)
SELECT FORMAT(Now(),'MMM YYYY') AS ConvertedColumnName FROM TableName;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)