Retrive only the date part from a datetime (TSQL)

This is one of the easiest ways to retrive only the date part from a DateTime value. Of course not some thing I invented but will be useful for others;

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