Find Month Name and Value from Month Year String

Rajnilari2015
Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 144
Given 'FEB 2017' find the Month Name and Value

SELECT 
MonthName = DATENAME(MONTH, 'FEB 2017')
,Month=MONTH('FEB 2017')


Result
---------
MonthName	Month
February 2

Comments or Responses

Login to post response