[Koha-bugs] [Bug 18985] New: SQL reports 'Last edit' and 'Last run' columns sort alphabetically, not chronologically

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

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

            Bug ID: 18985
           Summary: SQL reports 'Last edit' and 'Last run' columns sort
                    alphabetically, not chronologically
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Reports
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nick at bywatersolutions.com
        QA Contact: testopia at bugs.koha-community.org
        Depends on: 14365

To recreate:
Edit and run some reports and then modify the last edited/run dates to be:
7/24/2017 12:12:12
7/25/2016 12:12:12
7/26/2017 12:12:12

Sort by each column and note they will sort in the order above instead of the
expected:
7/25/2016 12:12:12
7/24/2017 12:12:12
7/26/2017 12:12:12


Referenced Bugs:

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14365
[Bug 14365] SQL Reports Last Edit Date column
-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.