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 <Tomas.Kopal@altap.cz> r=wicked, a=justdave

---
 Bugzilla/Search.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'Bugzilla/Search.pm')

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 " .
-- 
cgit v1.2.3-24-g4f1b