This works too:

set @start_of_day = cast(cast(@date as date) as datetime)