Seemingly simple SQL query

if you use datetime datatype for date and time

Select        Top 1 *
From    <table_name> 
Where   Convert(Date,<Datetime_column>) = Convert(Date,GETDATE())
Order   By <Datetime_column> Desc

if you use seperate column for date and time

Select Top 1 *
From <table_name>  
Where Convert(Date,<date_column>) = Convert(Date,GETDATE())
Order By <time_stamp_column> Desc