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

[Marcel de Rooy]

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<mailto: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<mailto: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<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" <magnus at enger.priv.no><mailto:magnus at enger.priv.no>
An: koha-devel at lists.koha-community.org<mailto: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><mailto: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<mailto: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<mailto: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<mailto: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<tel:+54%209%20351%20351-3384>
GPG: B2F3C15F
_______________________________________________
Koha-devel mailing list
Koha-devel at lists.koha-community.org<mailto: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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20180214/3df49d08/attachment.html>