These are functions to get just the date from datetime.

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

or :

declare @date datetime set @date=CONVERT(varchar(8), GETDATE(), 112)