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