with testdata as( select cast('10/1/2014 12:00:00 AM' 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/
SET DATEFORMAT DMYDECLARE @InputDate AS varchar(100) = '10/1/2014 12:00:00 AM'SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), cast( @InputDate as datetime), 106), 8), ' ', '-') AS [Mon-YYYY]
Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
Login to post response