sql get first day previous month code example

Example: sql server select first day of previous year

SELECT DATEFROMPARTS ( DATEPART(yyyy, GETDATE()) - 1, 1, 1 )