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 r=mkanat, a=justdave --- Bugzilla/Chart.pm | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'Bugzilla/Chart.pm') diff --git a/Bugzilla/Chart.pm b/Bugzilla/Chart.pm index 90c1ad16f..0836adde3 100644 --- a/Bugzilla/Chart.pm +++ b/Bugzilla/Chart.pm @@ -229,9 +229,9 @@ sub readData { } # Prepare the query which retrieves the data for each series - my $query = "SELECT TO_DAYS(series_date) - " . - " TO_DAYS(FROM_UNIXTIME($datefrom)), " . - "series_value FROM series_data " . + my $query = "SELECT " . $dbh->sql_to_days('series_date') . " - " . + $dbh->sql_to_days('FROM_UNIXTIME($datefrom)') . + ", series_value FROM series_data " . "WHERE series_id = ? " . "AND series_date >= FROM_UNIXTIME($datefrom)"; if ($dateto) { -- cgit v1.2.3-24-g4f1b