Hello,
BETWEEN doesn't give the result I would need when used with time before 
& after midnight:

SELECT time('23:00') BETWEEN time('22:00') AND time ('23:30');
time
----
1

sqlite> SELECT time('23:00') BETWEEN time('22:00') AND time ('01:00');
time
----
0

Any suggestion how to tweak the query to give "true" as the result even 
with midnight wrap around?

Reply via email to