If you are loading the date value into a datetime variable or a datetime column you only need to do the DATEDIFF.

DECLARE @dtDate datetime

SET @dtDate = datediff(d,0,getdate())

PRINT @dtDate

If you want to display the date value directly in a select then you'll need to convert it back to a datetime in some manner like the ones show in the article or in this thread. Note this method of stripping the time only works because SQL Server internally stores dates as numbers. If SQL Server were to change how it internally stores dates as numbers well then....who knows if these methods would work.