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 --- sanitycheck.cgi | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'sanitycheck.cgi') diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 8b7701eb1..63ddf181f 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -177,8 +177,8 @@ if (defined $cgi->param('rescanallBugMail')) { Status("OK, now attempting to send unsent mail"); SendSQL("SELECT bug_id FROM bugs WHERE lastdiffed < delta_ts AND - delta_ts < date_sub(now(), " . $dbh->sql_interval('30 minute') . - ") ORDER BY bug_id"); + delta_ts < now() - " . $dbh->sql_interval('30 minute') . + " ORDER BY bug_id"); my @list; while (MoreSQLData()) { push (@list, FetchOneColumn()); @@ -736,8 +736,8 @@ Status("Checking for unsent mail"); SendSQL("SELECT bug_id " . "FROM bugs WHERE lastdiffed < delta_ts AND ". - "delta_ts < date_sub(now(), " . $dbh->sql_interval('30 minute') . - ") ORDER BY bug_id"); + "delta_ts < now() - " . $dbh->sql_interval('30 minute') . + " ORDER BY bug_id"); while (@row = FetchSQLData()) { my ($id) = (@row); -- cgit v1.2.3-24-g4f1b