From 804a4999a84b827ac4ec3fa34158e097da31ade3 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Mon, 29 Oct 2007 10:31:31 +0000
Subject: mysql me 1.9 more times

---
 httemplate/search/cdr.html | 6 ++++--
 1 file changed, 4 insertions(+), 2 deletions(-)

(limited to 'httemplate/search/cdr.html')

diff --git a/httemplate/search/cdr.html b/httemplate/search/cdr.html
index 61d41f8d0..9426c33c3 100644
--- a/httemplate/search/cdr.html
+++ b/httemplate/search/cdr.html
@@ -48,10 +48,12 @@ if ( $cgi->param('freesidestatus') eq 'NULL' ) {
 # dates
 ###
 
+my $str2time_sql = str2time_sql;
+
 my($beginning, $ending) = FS::UI::Web::parse_beginning_ending($cgi);
 push @search,
-my @dsearch = ( "extract(epoch from calldate) >= $beginning ",
-                "extract(epoch from calldate) <= $ending"
+my @dsearch = ( "$str2time calldate) >= $beginning ",
+                "$str2time calldate) <= $ending"
 	      );
 push @search, @dsearch;
 push @qsearch, @search;
-- 
cgit v1.2.1