From 184af8a43f08f87c54bfb3c3287823917d2c1ba9 Mon Sep 17 00:00:00 2001
From: Holger Levsen <holger@layer-acht.org>
Date: Mon, 8 Feb 2016 15:05:21 +0100
Subject: reproducible debian: fix calculation of packages build in the last
 24h

---
 bin/reproducible_html_dashboard.sh | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'bin/reproducible_html_dashboard.sh')

diff --git a/bin/reproducible_html_dashboard.sh b/bin/reproducible_html_dashboard.sh
index 3a44f3da..21434ef3 100755
--- a/bin/reproducible_html_dashboard.sh
+++ b/bin/reproducible_html_dashboard.sh
@@ -323,7 +323,7 @@ write_build_performance_stats() {
 	done
 	write_page "</tr><tr><td>packages tested in the last 24h</td>"
 	for ARCH in ${ARCHS} ; do
-		RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > datetime('$(date -u '+%Y-%m-%d')', '-24 hours') AND r.architecture='$ARCH'")
+		RESULT=$(sqlite3 -init ${INIT} ${PACKAGES_DB} "SELECT COUNT(r.build_date) FROM stats_build AS r WHERE r.build_date > datetime('$(date -u '+%Y-%m-%d %H:%m')', '-24 hours') AND r.architecture='$ARCH'")
 		write_page "<td>$RESULT</td>"
 	done
 	write_page "</tr><tr><td>packages tested on average per day in the last $TIMESPAN_VERBOSE</td>"
-- 
cgit v1.2.3-70-g09d2