diff options
| author | mkanat%kerio.com <> | 2005-02-20 17:02:06 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-02-20 17:02:06 +0100 |
| commit | d7958942a691a719be4d3433b5a24817c8646f9a (patch) | |
| tree | 179648890480c617db96828c6b2a705f74a04d2d /contrib/sendunsentbugmail.pl | |
| parent | e547dd6d7b7b9a3c2135c56dd6b7a433743fd4b1 (diff) | |
| download | bugzilla-d7958942a691a719be4d3433b5a24817c8646f9a.tar.gz bugzilla-d7958942a691a719be4d3433b5a24817c8646f9a.tar.xz | |
Bug 280502: Replace "INTERVAL" with Bugzilla::DB function call
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave
Diffstat (limited to 'contrib/sendunsentbugmail.pl')
| -rw-r--r-- | contrib/sendunsentbugmail.pl | 4 |
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()); |