with testdata as( select cast('01-10-2014 00:00:00' as datetime) as d)SELECT DATENAME(MONTH,d)+'-'+DATENAME(year,d)
Thank you, Govind
Regards, Murugavel S murugavel.sadagopan@gmail.com http://murugavelmsc.blogspot.in/
DECLARE @InputDate VARCHAR(25) = '10/1/2014' --convert dd/mm/yyyy to mm-yyyy SELECT RIGHT(CONVERT(VARCHAR(10), CAST( @InputDate AS DATETIME), 105), 7) AS [MM-YYYY]
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
Login to post response