-- fiddle schema (LHS):
create table t( d date );

-- fiddle SQL (RHS):
insert into t 
   values 
      ( getdate()     )
    , ( getdate() + 1 )
;

-- t now contains 2 rows

select * from t where d = cast(getdate() as date);
-- returns only the one row