https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21105 David Cook <dcook@prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook@prosentient.com.au --- Comment #3 from David Cook <dcook@prosentient.com.au> --- Rudolf: It's just a formatting issue. If you examine your data, you'll see that the timestamp reported by oai.pl is in UTC. This is thanks to some cleverness in "Koha/OAI/Server/Repository.pm" that sets the the time zone to UTC in the MySQL client session. (Thanks Ere :D) So the following should be sufficient: SELECT DATE_FORMAT(MIN(timestamp),'%Y-%m-%dT%H:%i:%SZ') AS earliest FROM biblio; -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.