select rows by compare on datetime column

[Viswanatha Rao]

I have two columns in a table: start_time and end_time. Both are of
types DATETIME 
When I select rows from table, I want to select only those rows where
the current time falls between start_time and end_time
 
Can someone help with the SELECT syntax for this?
 
Best Regards
Vishwa Rao