Convert datetime to month in number and year

Question

I have a datetime e.g. 2014-04-24 00:28:53.897 and want to convert this in a select query to month in number and year - 4 2014.

Answer 1

Try this

SELECT FORMAT(GETDATE(),'MM yyyy')

replace getdate with you datetime column

Hope it help you.

Answer 2

Use DATEPART

SELECT CONCAT(DATEPART(mm,datefield),' ',DATEPART(yyyy,datefield)) AS monthyear
FROM yourtable

SQL FIDDLE: http://sqlfiddle.com/#!6/9c896/7/0