Answers for "get last date of month in sql"

sql server beginning of month

SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth

Posted by: Guest on May-29-2020

get current month last date in sql server

SELECT EOMONTH('2019-02-15') end_of_month_feb2019;

Posted by: Guest on August-19-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 "get last date of month in sql"