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?

