Actually we already have Bug 14717: Prevent 0000-00-00 dates in patron data) on 3.21.00.023 which does that!
On Wed, 14 Feb 2018 at 13:03 Tomas Cohen Arazi <tomasco...@gmail.com> wrote: > It should be null. > > El mié., 14 feb. 2018 a las 12:58, Jonathan Druart (< > jonathan.dru...@bugs.koha-community.org>) escribió: > >> yes could be NULL instead. >> (date calculation perf issue is fixed) >> >> On Wed, 14 Feb 2018 at 12:50 Marcel de Rooy <m.de.r...@rijksmuseum.nl> >> wrote: >> >>> 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> >>> 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>) 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 >>> <+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> <mag...@enger.priv.no> >>> *An:* 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> >>> <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 >>> 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 >>> listkoha-de...@lists.koha-community.orghttp://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/ >>> >>> -- >>> Tomás Cohen Arazi >>> Theke Solutions (https://theke.io <http://theke.io/>) >>> ✆ +54 9351 3513384 <+54%209%20351%20351-3384> >>> GPG: B2F3C15F >>> _______________________________________________ >>> 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/ >>> >>> _______________________________________________ >>> 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/ >> >> _______________________________________________ >> 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/ > > -- > Tomás Cohen Arazi > Theke Solutions (https://theke.io <http://theke.io/>) > ✆ +54 9351 3513384 <+54%209%20351%20351-3384> > GPG: B2F3C15F >
_______________________________________________ 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/
