From e547dd6d7b7b9a3c2135c56dd6b7a433743fd4b1 Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Sun, 20 Feb 2005 15:53:16 +0000
Subject: Bug 280499: Replace "TO_DAYS()" with Bugzilla::DB function call Patch
 By Tomas Kopal <Tomas.Kopal@altap.cz> r=mkanat, a=justdave

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

(limited to 'Bugzilla/Search.pm')

diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm
index 6584f1080..82cbb9aa6 100644
--- a/Bugzilla/Search.pm
+++ b/Bugzilla/Search.pm
@@ -797,7 +797,8 @@ sub init {
          },
          
          "^changedin," => sub {
-             $f = "(to_days(now()) - to_days(bugs.delta_ts))";
+             $f = "(" . $dbh->sql_to_days('NOW()') . " - " .
+                        $dbh->sql_to_days('bugs.delta_ts') . ")";
          },
 
          "^component,(?!changed)" => sub {
-- 
cgit v1.2.3-24-g4f1b