Find Year from Month Year String

Posted by Rajnilari2015 under Sql Server category on 2/13/2017 | Points: 40 | Views : 1067

Given 'FEB 2017' find the Year


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

Result
--------

Year	Year
2017	2017

Bookmark It

Latest Code Snipptes