Comparar hora

[etapombas 0]

Galera to apanhando mto pra fazer uma comparação simples de horaEu preciso comparar se a hora...hora inicio07:00hora fim09:00------------esta entre------------hora incio07:00hora fim08:00ate cheguei a montar uma instrucao sqlporem ele nao entende que das 7h as 9h esta entre as 7h as 8hSELECT * FROM agenda WHERE (TIME('07:00') BETWEEN horainicio AND horafim) AND (TIME('09:00') BETWEEN horainicio AND horafim)

[Eclesiastes 2]

SELECT * FROM agenda WHERE ('07:00:00' BETWEEN horainicio AND horafim) AND horafim <= '09:00:00'