Where time condition.

I have a field in the table of type ‘TIME’ i am storing the transaction time in this filed.

i.e. 02:20:20 pm

how can i write the select statement to get the records between the range of time e.g

select from TransactionTable where TransactionTable.TransTime <= ‘02:20:20 pm’ and TransactionTable.TransTime <= ‘10:20:20 pm’

Please guide.

Use before the select statement str2time(), time2str() and set them values to variables, put those variables inside the where condition.