Fix DB warning being shown by zurich-overdue-alert

A raw DateTime object was being passed as a parameter in an SQL
query, which was causing undefined behaviour and a warning
every time the Zurich overdue problems script was run.

The DateTime is now converted into a format suitable for use in
the query and the warning has gone.

1 files changed, 3 insertions, 1 deletions

diff --git a/bin/zurich-overdue-alert b/bin/zurich-overdue-alert
index 4e81b3263..e7c23b493 100755
--- a/bin/zurich-overdue-alert
+++ b/bin/zurich-overdue-alert
@@ -29,10 +29,12 @@ loop_through( 'alert-overdue.txt', 0, 6, ['confirmed', 'planned'] );
 
 sub loop_through {
     my ( $template, $include_parent, $days, $states ) = @_;
+    my $dtf = FixMyStreet::App->model("DB")->storage->datetime_parser;
+    my $date_threshold = $dtf->format_datetime(FixMyStreet::Cobrand::Zurich::sub_days( $now, $days ));
 
     my $reports = FixMyStreet::App->model("DB::Problem")->search( {
         state => $states,
-        created => { '<', FixMyStreet::Cobrand::Zurich::sub_days( $now, $days ) },
+        created => { '<',  $date_threshold },
         bodies_str => { '!=', undef },
     } );