http://strangenut.com/blogs/dacrowlah/archive/2010/01/28/how-to-select-only-the-date-part-of-a-datetime-field-in-sql-sql-server-2000-2005-2008.aspxHave you ever needed to get only the date part out of a datetime field in SQL and wanted to drop the precision of the timepart? It's actually surprisingly easy, and with this method is pretty fast as well. I've had to do this many times but alwaysenCommunityServer 2008 SP1 (Build: 30619.63)