There are likely other ways to achieve this, but you can do the following:
Select * from TableName T
where T.Date = Convert(date,getdate())
and T.Time = CONVERT(time,getdate())
You get records where the date and time match the current date and time EXACTLY.
--------------------------------------------------------------------------
When you realize you've dug yourself into a hole....Step 1...stop digging.