Getting a “pure” date in MS SQL (without the time)
You probably know the situation: You want to get all records grouped by day, but you stored their creation date using getdate(), so now they all contain time as well as the date.
The solution until MS SQL 2008 was not pretty, however with MS SQL 2008 we finally have a “pure” date datatype.