Date Flattening (Removing the time from a existing date field)

Date Flattening in SQL Server 2005/2008.


Select DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)