summaryrefslogtreecommitdiffstats
path: root/contrib/sendunsentbugmail.pl
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/sendunsentbugmail.pl')
-rw-r--r--contrib/sendunsentbugmail.pl4
1 files changed, 3 insertions, 1 deletions
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());