T-SQL Script: Get Start/end of month
T-SQL Script: Get Start/end of month
SELECT
DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS StartOfMonth,
EOMONTH(GETDATE()) AS EndOfMonth;
DATEFROMPARTS(YEAR(GETDATE()), MONTH(GETDATE()), 1) AS StartOfMonth,
EOMONTH(GETDATE()) AS EndOfMonth;