diff options
| author |   mkanat%kerio.com <> | 2005-03-03 15:19:09 +0000 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-03-03 15:19:09 +0000 |
| commit | 7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba (patch) | |
| tree | e509aee1bc024c0d486e557cd3f7a2e9750f45e8 /contrib | |
| parent | Bug 284172: checksetup cannot run CREATE DATABASE on PostgreSQL (diff) | |
| download | bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.tar.gz bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.tar.bz2 bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.zip | |
Bug: 284244: DATE_SUB and DATE_ADD are not ANSI SQL
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=wicked, a=justdave
Diffstat (limited to 'contrib')
| -rw-r--r-- | contrib/sendunsentbugmail.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/sendunsentbugmail.pl b/contrib/sendunsentbugmail.pl index b17289592..35b6a4941 100644 --- a/contrib/sendunsentbugmail.pl +++ b/contrib/sendunsentbugmail.pl @@ -31,7 +31,7 @@ use Bugzilla::BugMail; my $dbh = Bugzilla->dbh; SendSQL("SELECT bug_id FROM bugs WHERE lastdiffed < delta_ts AND - delta_ts < date_sub(now(), " . $dbh->sql_interval('30 minute') . + delta_ts < NOW() - " . $dbh->sql_interval('30 minute') . " ORDER BY bug_id"); my @list; while (MoreSQLData()) { |