Answers for "previous month first of the date in SQL server"

sql beginning of previous month

SELECT DATEADD(d,1,EOMONTH(GETDATE(),-2))

Posted by: Guest on May-12-2021

sql server select first day of previous year

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

Posted by: Guest on November-04-2020

Code answers related to "previous month first of the date in SQL server"