summary refs log tree commit diff
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2019-12-30 23:28:59 -0500
committerJune McEnroe <june@causal.agency>2019-12-30 23:28:59 -0500
commiteef9c0faa89365a9c4a94c13de2fc81cadd24396 (patch)
treea55e5d9c2c674dcaf991cb47b16dc0821cf329fd
parentAdd initial rough version of scoop (diff)
downloadlitterbox-eef9c0faa89365a9c4a94c13de2fc81cadd24396.tar.gz
litterbox-eef9c0faa89365a9c4a94c13de2fc81cadd24396.zip
Normalize date input
Mostly this just allows the use of 'now'.
-rw-r--r--scoop.c2
1 files changed, 1 insertions, 1 deletions
diff --git a/scoop.c b/scoop.c
index 48f291c..f735fe2 100644
--- a/scoop.c
+++ b/scoop.c
@@ -45,7 +45,7 @@ static const char *Inner = SQL(
 	WHERE coalesce(contexts.network = :network, true)
 		AND coalesce(contexts.name = :context, true)
 		AND coalesce(contexts.query = :query, true)
-		AND coalesce(date(events.time) = :date, true)
+		AND coalesce(date(events.time) = date(:date), true)
 		AND coalesce(events.type = :type, true)
 		AND coalesce(names.nick = :nick, true)
 		AND coalesce(names.user = :user, true)