[Koha-devel] 0000-00-00 is expired?

[Jonathan Druart]

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 <tomascohen at gmail.com> wrote:

> It should be null.
>
> El mié., 14 feb. 2018 a las 12:58, Jonathan Druart (<
> jonathan.druart at 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.Rooy at rijksmuseum.nl>
>> wrote:
>>
>>> Sounds to me like NULL was meant ?
>>>
>>> Using 9999-12-31 resulted in expensive date calculations previously.
>>>
>>>
>>>
>>> ------------------------------
>>> *Van:* koha-devel-bounces at lists.koha-community.org <
>>> koha-devel-bounces at lists.koha-community.org> namens Jonathan Druart <
>>> jonathan.druart at bugs.koha-community.org>
>>> *Verzonden:* woensdag 14 februari 2018 16:41
>>> *Aan:* koha-devel at 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 <tomascohen at 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.meynieux at 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" <magnus at enger.priv.no> <magnus at enger.priv.no>
>>> *An:* koha-devel at lists.koha-community.org
>>> *Betreff:* Re: [Koha-devel] 0000-00-00 is expired?
>>> Hiya!
>>>
>>> On 13 February 2018 at 20:06, Jonathan Druart
>>> <jonathan.druart at bugs.koha-community.org>
>>> <jonathan.druart at 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 at 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-devel at 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 at 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 at 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 at 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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20180214/6abd6af9/attachment-0001.html>