This is how we get the date for the current day without time element

DECLARE @a INT

DECLARE @b-2 DATETIME

set @b-2 = GETDATE()-.5

SET @a = CONVERT(INT,@b)

SELECT CONVERT(DATETIME, @a), @b-2

the -.5 is half a day because CONVERT(INT,@b) rounds