Getting Just Date from DateTime

Here it is...

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

Thanks Mr. Lubarsky