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 "
SET returndate = NULL
WHERE CAST(returndate AS CHAR(10)) = '0000-00-00';
"] at (eval 1481) line 5
RMaints, keep an eye on this one, you may need to backport it quickly.
Created attachment 117432 [details] [review]
Bug 27821: Make sanitize_zero_date support datetime and timestamp
Pushed to master for 21.05, thanks to everybody involved!
Pushed to 20.11.x for 20.11.04
Pushed to 20.05.x for 20.05.10
Backported: Pushed to 19.11.x branch for 19.11.16