mysql me 1.9 more times

1 files changed, 4 insertions, 2 deletions

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;