From d7958942a691a719be4d3433b5a24817c8646f9a Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Sun, 20 Feb 2005 16:02:06 +0000
Subject: Bug 280502: Replace "INTERVAL" with Bugzilla::DB function call Patch
 By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave

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

(limited to 'contrib/sendunsentbugmail.pl')

diff --git a/contrib/sendunsentbugmail.pl b/contrib/sendunsentbugmail.pl
index ffe892e08..b17289592 100644
--- a/contrib/sendunsentbugmail.pl
+++ b/contrib/sendunsentbugmail.pl
@@ -29,8 +29,10 @@ require "CGI.pl";
 use Bugzilla::Constants;
 use Bugzilla::BugMail;
 
+my $dbh = Bugzilla->dbh;
 SendSQL("SELECT bug_id FROM bugs WHERE lastdiffed < delta_ts AND 
-         delta_ts < date_sub(now(), INTERVAL 30 minute) ORDER BY bug_id");
+         delta_ts < date_sub(now(), " . $dbh->sql_interval('30 minute') .
+        " ORDER BY bug_id");
 my @list;
 while (MoreSQLData()) {
     push (@list, FetchOneColumn());
-- 
cgit v1.2.3-24-g4f1b