sql server how to get day of the year code example Example: sql server select furst day of current year SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0)