From 499a136441e41a3ab046d43bc8a925d9f10a479a Mon Sep 17 00:00:00 2001
From: "C. McEnroe" <june@causal.agency>
Date: Tue, 7 Jul 2020 13:31:58 -0400
Subject: Use >= and < on events.time for -D

This will enable the use of an index on events.time.
---
 scoop.c | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/scoop.c b/scoop.c
index f49f09a..9605530 100644
--- a/scoop.c
+++ b/scoop.c
@@ -402,7 +402,8 @@ int main(int argc, char *argv[]) {
 	for (int opt; 0 < (opt = getopt(argc, argv, Opts));) {
 		switch (opt) {
 			break; case 'D': {
-				append(where, SQL(AND date(events.time) = date(:date)));
+				append(where, SQL(AND events.time >= date(:date)));
+				append(where, SQL(AND events.time < date(:date, '+1 day')));
 				binds[n++] = Bind(":date", optarg, 0);
 			}
 			break; case 'F': {
-- 
cgit 1.4.1