SQL: Think that T-SQL EOMONTH() just returns the end of month? Think again...

In a recent post, I wrote how the T-SQL TRIM() function was more than just an LTRIM(RTRIM()) and that it took me a while to realize that. Well today, I found another one that I hadn't noticed before: EOMONTH. I was writing a SELECT clause for a query, when the Intellisense popped up: And suddenly ...