https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27821 Bug ID: 27821 Summary: sanitize_zero_date does not handle datetime Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: major Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart@bugs.koha-community.org Reporter: jonathan.druart@bugs.koha-community.org QA Contact: testopia@bugs.koha-community.org Only datatype "date" is handled correctly. Atomic update generated errors: main::sanitize_zero_date(): DBI Exception: DBD::mysql::db do failed: Truncated incorrect CHAR(10) value: '2021-03-01 09:43:56' [for Statement " UPDATE old_issues SET returndate = NULL WHERE CAST(returndate AS CHAR(10)) = '0000-00-00'; "] at (eval 1481) line 5 -- You are receiving this mail because: You are watching all bug changes.