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.