https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37416 --- Comment #4 from David Nind <david@davidnind.com> --- SQL query to identify dates with 0000-00-00 =========================================== Date fields in the items table: dateaccessioned, replacementpricedate, datelastborrowed, datelastseen, damaged_on, itemlost_on, withdrawn_on, deleted_on, onloan Not sure about: timestamp Identify any date fields with 000-00-00 values: ----------------------------------------------- select dateaccessioned, replacementpricedate, datelastborrowed, datelastseen, damaged_on, itemlost_on, withdrawn_on, deleted_on, onloan FROM items WHERE dateaccessioned LIKE '0000-00-00%' OR replacementpricedate LIKE '0000-00-00%' OR datelastborrowed LIKE '0000-00-00%' OR datelastseen LIKE '0000-00-00%' OR damaged_on LIKE '0000-00-00%' OR itemlost_on LIKE '0000-00-00%' OR withdrawn_on LIKE '0000-00-00%' OR deleted_on LIKE '0000-00-00%' OR onloan LIKE '0000-00-00%' SQL to fix date issues (example): --------------------------------- UPDATE items SET replacementpricedate = null WHERE replacementpricedate = '0000-00-00' Source - Chats: - https://chat.koha-community.org/koha-community/pl/wjyuc67s3jgsf88kze8nzgiqne - https://chat.koha-community.org/koha-community/pl/d3rnttkbz3b1ijcb9s8fgp58xo -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.