From 7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Thu, 3 Mar 2005 15:19:09 +0000 Subject: Bug: 284244: DATE_SUB and DATE_ADD are not ANSI SQL Patch By Tomas Kopal r=wicked, a=justdave --- contrib/sendunsentbugmail.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'contrib/sendunsentbugmail.pl') 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()) { -- cgit v1.2.3-24-g4f1b