From 02a049703de6055f09f44f89a5a821814696ce32 Mon Sep 17 00:00:00 2001
From: Max Kanat-Alexander <mkanat@bugzilla.org>
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.

---
 contrib/sendunsentbugmail.pl | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'contrib')

diff --git a/contrib/sendunsentbugmail.pl b/contrib/sendunsentbugmail.pl
index ec92a97a0..6ddbd2e4c 100755
--- a/contrib/sendunsentbugmail.pl
+++ b/contrib/sendunsentbugmail.pl
@@ -35,7 +35,8 @@ my $list = $dbh->selectcol_arrayref(
         'SELECT bug_id FROM bugs 
           WHERE lastdiffed IS NULL
              OR lastdiffed < delta_ts 
-            AND delta_ts < NOW() - ' . $dbh->sql_interval(30, 'MINUTE') .
+            AND delta_ts < ' 
+                . $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE') .
      ' ORDER BY bug_id');
 
 if (scalar(@$list) > 0) {
-- 
cgit v1.2.3-24-g4f1b