Find Year from Month Year String

Rajnilari2015
Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 230
Given 'FEB 2017' find the Year

SELECT
Year = DATENAME(YEAR, 'FEB 2017')
,Year=YEAR('FEB 2017')


Result
--------
Year	Year
2017 2017

Comments or Responses

Login to post response