[Koha-bugs] [Bug 17001] New: filtering overdue report by due date can fail if TimeFormat is 12hr

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17001

            Bug ID: 17001
           Summary: filtering overdue report by due date can fail if
                    TimeFormat is 12hr
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Circulation
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: gmcharlt at gmail.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at gmail.com

When using the overdue report circ/overdue.pl, if the TimeFormat system
preference is set to 12-hour, setting a filter on the due date range can result
in zero overdue loans being displayed, even if there are ones that fall in the
range.

This happens because the date/time that gets passed to the SQL is formatted
incorrectly; rather than '2016-07-29 23:59', it gets passed as '2016-07-29
11:59 PM'; on many MySQL and MariaDB versions, that becomes NULL when cast to a
datetime.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.