Sounds to me like NULL was meant ? Using 9999-12-31 resulted in expensive date calculations previously.
________________________________ Van: koha-devel-boun...@lists.koha-community.org <koha-devel-boun...@lists.koha-community.org> namens Jonathan Druart <jonathan.dru...@bugs.koha-community.org> Verzonden: woensdag 14 februari 2018 16:41 Aan: koha-devel@lists.koha-community.org Onderwerp: Re: [Koha-devel] 0000-00-00 is expired? Great news then :) Sophie and Bob, could you determine what means this value? Would it make sense to update it with 9999-12-31 and consider it as "will never expired"? On Wed, 14 Feb 2018 at 12:13 Tomas Cohen Arazi <tomasco...@gmail.com<mailto:tomasco...@gmail.com>> wrote: In all my 65 instances, there's not '0000-00-00'. This is probably a data migration issue. El mié., 14 feb. 2018 a las 11:05, Sophie Meynieux (<sophie.meyni...@biblibre.com<mailto:sophie.meyni...@biblibre.com>>) escribió: Hello, For all our customers that are hosted on our servers, only one has one patron with dateexpiry = "0000-00-00" Regards S. Meynieux -- Responsable support BibLibre + 33 (0)4 91 81 35 08<tel:+33%204%2091%2081%2035%2008> http://www.biblibre.com Le 14/02/2018 à 12:12, Katrin Fischer a écrit : I've also checked our oldest 5 - didn't find any patrons with dateexpiry 0000-00-00. Gesendet: Mittwoch, 14. Februar 2018 um 08:18 Uhr Von: "Magnus Enger" <mag...@enger.priv.no><mailto:mag...@enger.priv.no> An: koha-devel@lists.koha-community.org<mailto:koha-devel@lists.koha-community.org> Betreff: Re: [Koha-devel] 0000-00-00 is expired? Hiya! On 13 February 2018 at 20:06, Jonathan Druart <jonathan.dru...@bugs.koha-community.org><mailto:jonathan.dru...@bugs.koha-community.org> wrote: > It would be useful to know the return of > SELECT COUNT(*) FROM borrowers where dateexpiry="0000-00-00" > on old installations. I just checked my 5 oldest instances (upgraded regularly since 2009/2010) and none of them had any users meeting this criterium. Best regards, Magnus Libriotech _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/ -- Tomás Cohen Arazi Theke Solutions (https://theke.io<http://theke.io/>) ✆ +54 9351 3513384<tel:+54%209%20351%20351-3384> GPG: B2F3C15F _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org<mailto:Koha-devel@lists.koha-community.org> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
