# HG changeset patch
# User Daniel Poelzleithner <poelzi@poelzi.org>
# Date 1286195833 -7200
# Node ID eb6509288d67081be09fe38bb3a6f141ab08f54b
# Parent  f740026b151867020a82a1c5f38eda2beac526e3
don't show second fractions on time_left

diff -r f740026b1518 -r eb6509288d67 model/issue.lua
--- a/model/issue.lua	Mon Sep 20 20:32:04 2010 +0200
+++ b/model/issue.lua	Mon Oct 04 14:37:13 2010 +0200
@@ -208,7 +208,7 @@
     last_event_time = self.fully_frozen
     duration = self.voting_time
   end
-  return db:query{ "SELECT ?::timestamp + ?::interval - now() as time_left", last_event_time, duration }[1].time_left
+  return db:query{ "SELECT ?::timestamp + ?::interval - CURRENT_TIMESTAMP(0) as time_left", last_event_time, duration }[1].time_left
 end
 
 function Issue.object_get:next_states()