Answers for "get first date of previous month 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 "get first date of previous month in sql server"