select orderdate from Sales.Orders
where orderdate =EOMONTH(orderdate);
or
SELECT EOMONTH(SYSDATETIME());