sql select first day prior year code example Example: sql server select first day of previous year SELECT DATEFROMPARTS ( DATEPART(yyyy, GETDATE()) - 1, 1, 1 )