sqlsql-servert-sqlsql-server-2014

Convert SQL Server Date to mm-yyyy


I'm trying to convert my Date which is (eg. 2012-04-20 05:54:59) format in into mm-yyyy. I came across some solutions that says you would need to convert into varchar . Is there any way using the Convert function ?

Thanks :)


Solution

  • You can use FORMAT function, available from SQL Server 2012 onwards:

    DECLARE @myDate DATETIME = '2012-04-20 05:54:59'
    SELECT FORMAT(@myDate, 'MM-yyyy') 
    

    Output:

    04-2012