From 02a049703de6055f09f44f89a5a821814696ce32 Mon Sep 17 00:00:00 2001 From: Max Kanat-Alexander Date: Thu, 7 Oct 2010 03:58:28 -0700 Subject: Bug 602165: Change sql_interval to sql_date_math, in preparation for MS-SQL and SQLite support. --- duplicates.cgi | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'duplicates.cgi') 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); -- cgit v1.2.1