about summary refs log tree commit diff
diff options
context:
space:
mode:
-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);