summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2020-07-08 13:03:25 -0400
committerJune McEnroe <june@causal.agency>2020-07-08 13:03:25 -0400
commit27937a5d0e5d3756e43b2c726e084ef9bc549c18 (patch)
treedc1d698ba62f9598d09772117c95b07c728034be
parentConvert timestamps to unix epoch time (diff)
downloadlitterbox-27937a5d0e5d3756e43b2c726e084ef9bc549c18.tar.gz
litterbox-27937a5d0e5d3756e43b2c726e084ef9bc549c18.zip
Fix -D now
-rw-r--r--scoop.c5
1 files changed, 3 insertions, 2 deletions
diff --git a/scoop.c b/scoop.c
index fed05ec..c4a7736 100644
--- a/scoop.c
+++ b/scoop.c
@@ -404,8 +404,9 @@ int main(int argc, char *argv[]) {
 				append(
 					where,
 					SQL(
-						AND events.time >= strftime('%s', :date)
-						AND events.time < strftime('%s', :date, '+1 day')
+						AND events.time >= strftime('%s', :date, 'start of day')
+						AND events.time
+							< strftime('%s', :date, 'start of day', '+1 day')
 					)
 				);
 				binds[n++] = Bind(":date", optarg, 0);