raresql.com
SQL SERVER 2012 – Get Day, Month and Year separately from Date Time Using Format Function
How to get day, month and year from Date Time? I came across this question many times in multiple blogs and there are many ways to do it in the earlier versions of SQL Server. In SQL Server 2012, y…