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?