Please try this

SELECT DATEADD(dd,DATEDIFF(dd,0,getdate()),0)

Which will give the date with no time.

2011-08-03 00:00:00.000

Good article with detailed explanation for programmers who are new to SQL DMO.

Thanks