请取出 BORROW表中日期(RDATE字段)为当天的所有记录?(RDATE字段为datetime型, 包含日期与时间)。SQL语句实现正确的是:( )
select * from borrow where datediff(dd,rdate,getdate())=0
select * from borrow where rdate=getdate()
select * from borrow where rdate-getdate()=0
select * from borrow where rdate > getdate()