Hi,
In my case time column has a varchar. ALso I did a test for performance by using "set timing on" and found that uday's solution is faster than marist89's.

Otherwise marist89's solution is a better one if time column is of date datatype.

Thanks
Anurag