Date Time in SQL Server 2005

Question

I have a datetime column in table that has time component.

Is there anyway I can set '2011-03-14 11:46:31' to '2011-03-14 00:00:00'?

Answer 1

declare @date as datetime

set @date = getdate()

Select  Cast(Floor(Cast(@date as float)) as DateTime)

Answer 2

Prior to 2k8 I always;

DATEADD(DAY, DATEDIFF(DAY, 0, datecol), 0)