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