Here's another method for removing the time from a datetime value I picked up from a colleague.

select dateadd(day,0,datediff(day,0,getdate()))