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.