between,interval... perche'?

non ti basta:
"select programma from palinsesto where `ora` < curtime() limit 1"
?