diff options
| author | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 12:58:28 +0200 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 12:58:28 +0200 |
| commit | 02a049703de6055f09f44f89a5a821814696ce32 (patch) | |
| tree | 5918c91ceea49d280c8c3c0ce795da549a8bf4c6 /contrib/sendunsentbugmail.pl | |
| parent | 7307c8c748e3245d65a25c016e7d92c6c7ae2aa4 (diff) | |
| download | bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.gz bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.xz | |
Bug 602165: Change sql_interval to sql_date_math, in preparation for
MS-SQL and SQLite support.
Diffstat (limited to 'contrib/sendunsentbugmail.pl')
| -rwxr-xr-x | contrib/sendunsentbugmail.pl | 3 |
1 files changed, 2 insertions, 1 deletions
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) { |