[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    bugs/bugz
From:       Dirk Mueller <mueller () kde ! org>
Date:       2005-06-02 23:33:04
Message-ID: 1117755184.976911.16598.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 421389 by mueller:

now it works for large timeframes as well



 M  +3 -1      weekly-summary-utils.pl  


--- trunk/bugs/bugz/weekly-summary-utils.pl #421388:421389
@@ -368,7 +368,9 @@
     # We are going to build a long SQL query.
     $query = <<FIN;
 SELECT
-    profiles.login_name, bugs.bug_id, min(bugs_activity.bug_when-bugs.creation_ts) as open_time
+    profiles.login_name, bugs.bug_id, 
+    MIN(UNIX_TIMESTAMP(bugs_activity.bug_when)-UNIX_TIMESTAMP(bugs.creation_ts))
+        AS open_time
 FROM
     bugs, bugs_activity, profiles
 WHERE
[prev in list] [next in list] [prev in thread] [next in thread]