[Koha-bugs] [Bug 26026] New: cleanup_database does not allow to purge data created today

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

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

            Bug ID: 26026
           Summary: cleanup_database does not allow to purge data created
                    today
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: Command-line Utilities
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: jonathan.druart at bugs.koha-community.org
        QA Contact: testopia at bugs.koha-community.org
                CC: robin at catalyst.net.nz

The query is built with WHERE expiration < date_sub(CURDATE(), INTERVAL ? DAY),
which truncate to day

MariaDB [koha_kohadev]> SELECT DATE_SUB(CURDATE(), INTERVAL 0 DAY);
+-------------------------------------+
| DATE_SUB(CURDATE(), INTERVAL 0 DAY) |
+-------------------------------------+
| 2020-07-20                          |
+-------------------------------------+

It makes it impossible to remove the data from today.

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