9/29/2010 11:43:44 AM
Instead of converting datatypes (to varchar) back and forth, this is much faster.
SELECT DATEADD(dd, (DATEDIFF(dd, 0, t.DateTimeColumn)), 0) FROM Table t;
It calculates the number of days from year 0 to the date and add that value to the date 0. All datetime type.