Bug 5549 : Cannot use CUR_DATE on date_due column

Comparison of CUR_TIME() & datetime gives
table corrupted error in mysql
Plus we want to see hourly loans

diff --git a/C4/Overdues.pm b/C4/Overdues.pm
index 660e10b..afccdb5 100644 (file)
--- a/C4/Overdues.pm
+++ b/C4/Overdues.pm
@@ -1218,7 +1218,7 @@ sub GetOverduesForBranch {
     WHERE (accountlines.amountoutstanding  != '0.000000')
       AND (accountlines.accounttype         = 'FU'      )
       AND (issues.branchcode =  ?   )
-      AND (issues.date_due  < CURDATE())
+      AND (issues.date_due  < NOW())
     ";
     my @getoverdues;
     my $i = 0;