svn commit: r334092 - user/des/fbce/db

[Dag-Erling Smørgrav]

Author: des
Date: Wed May 23 11:59:29 2018
New Revision: 334092
URL: https://svnweb.freebsd.org/changeset/base/334092

Log:
  Modify SQL query so it produces the correct result even if run after the
  start of the election.

Modified:
  user/des/fbce/db/notes

Modified: user/des/fbce/db/notes
==============================================================================
--- user/des/fbce/db/notes	Wed May 23 11:45:46 2018	(r334091)
+++ user/des/fbce/db/notes	Wed May 23 11:59:29 2018	(r334092)
@@ -59,7 +59,7 @@ perl -Ilib -MFBCE -e 'map { $_->reset_password() } FBC
 # fst3k=# \t on
 # Showing only tuples.
 # fst3k=# \o active-20180516.txt
-# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '2017-05-16' group by p.login order by p.login;
+# fst3k=# select p.login from persons p join revisions r on p.id = r.author where r.datetime >= '20170516T180000Z' and r.datetime <'20180516T180000Z' group by p.login order by p.login;
 # fst3k=# \o
 #
 ./script/fbce_user.pl activate active-20180516.txt