From cb170fe4ff807a9299adfb56acf84e66996f20f1 Mon Sep 17 00:00:00 2001
From: Colin Campbell <colin.campbell@ptfs-europe.com>
Date: Fri, 17 Jun 2011 12:13:47 +0100
Subject: [PATCH 1/1] 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
---
 C4/Overdues.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Overdues.pm b/C4/Overdues.pm
index 660e10b830..afccdb5cd5 100644
--- 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;
-- 
2.20.1