Days in a Year (SQL Server)

1) The first solution

--Work with SQL server 2005 and above.

DECLARE @year AS INT SET @year=2015

SELECT DATEPART(dy,(DATEADD(YEAR,@year-1899,0)-1)) as TotalDays

GO

2) Second Solution

--Work with SQL server 2012 and above.

DECLARE @year AS INT

SET @year=2015

SELECT DATEPART(dy,DATEFROMPARTS(@Year,12,31))

AS TotalDays

Go