Find rows with last date of month - SQL Snipplr Social Repository

Revision: 52984

at November 9, 2011 01:27 by danfsmith

Initial Code

SELECT orderid, orderdate, custid, empid
FROM Sales.Orders
WHERE orderdate = DATEADD(month, DATEDIFF(month, '19991231', orderdate), '19991231');

Initial URL

Initial Description

Initial Title

Find rows with last date of month

Initial Tags

sql, date

Initial Language

SQL