Answers for "mssql get first day of last month"

sql server select first day of previous year

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

Posted by: Guest on November-04-2020

mssql last day of month

SELECT DATEADD(month, ((YEAR(getdate()) - 1900) * 12) + MONTH(getdate()), -1)

Posted by: Guest on July-16-2020

Code answers related to "mssql get first day of last month"