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 --- Bugzilla/Search.pm | 2 +- Bugzilla/Token.pm | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) (limited to 'Bugzilla') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index f2e630784..1a0cb9a7f 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -922,7 +922,7 @@ sub init { } elsif ($unit eq 'y') { $unitinterval = 'YEAR'; } - my $cutoff = "DATE_SUB(NOW(), " . + my $cutoff = "NOW() - " . $dbh->sql_interval("$quantity $unitinterval"); my $assigned_fieldid = &::GetFieldID('assigned_to'); push(@supptables, "LEFT JOIN longdescs comment_$table " . diff --git a/Bugzilla/Token.pm b/Bugzilla/Token.pm index 73f074185..feca00c3b 100644 --- a/Bugzilla/Token.pm +++ b/Bugzilla/Token.pm @@ -119,8 +119,8 @@ sub IssuePasswordToken { LEFT JOIN tokens ON tokens.userid = profiles.userid AND tokens.tokentype = 'password' - AND tokens.issuedate > DATE_SUB(NOW(), " . - $dbh->sql_interval('10 MINUTE') . ") + AND tokens.issuedate > NOW() - " . + $dbh->sql_interval('10 MINUTE') . " WHERE login_name = $quotedloginname"); my ($userid, $toosoon) = &::FetchSQLData(); -- cgit v1.2.3-24-g4f1b