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@rijksmuseum.nl> wrote:

Sounds to me like NULL was meant ?

Using 9999-12-31 resulted in expensive date calculations previously.

---

Van: koha-devel-bounces@lists.koha-community.org <koha-devel-bounces@lists.koha-community.org> namens Jonathan Druart <jonathan.druart@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 <tomascohen@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@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
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@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.druart@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 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)
✆ +54 9351 3513384
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/