get day of year sql server code example
Example 1: get day in sql
SELECT DATEPART(m, GETDATE()) as theMonth -- returns 11
SELECT DATEPART(d, GETDATE()) as theDay -- returns 20
SELECT DATEPART(yy, GETDATE()) as theYear -- returns 2013
Example 2: sql server select furst day of current year
SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0)