Bug 602165: Change sql_interval to sql_date_math, in preparation for

MS-SQL and SQLite support.

1 files changed, 2 insertions, 2 deletions

diff --git a/duplicates.cgi b/duplicates.cgi
index 2a52742c6..798599ed0 100755
--- a/duplicates.cgi
+++ b/duplicates.cgi
@@ -181,8 +181,8 @@ my %since_dups = @{$dbh->selectcol_arrayref(
        FROM duplicates INNER JOIN bugs_activity 
                        ON bugs_activity.bug_id = duplicates.dupe 
       WHERE added = 'DUPLICATE' AND fieldid = ? 
-            AND bug_when >= LOCALTIMESTAMP(0) - "
-                . $dbh->sql_interval('?', 'DAY') .
+            AND bug_when >= "
+                . $dbh->sql_date_math('LOCALTIMESTAMP(0)', '-', '?', 'DAY') .
  " GROUP BY dupe_of", {Columns=>[1,2]},
     $reso_field_id, $changedsince)};
 add_indirect_dups(\%since_dups, \%dupe_relation);