<div dir="ltr">It should be null.</div><br><div class="gmail_quote"><div dir="ltr">El mié., 14 feb. 2018 a las 12:58, Jonathan Druart (<<a href="mailto:jonathan.druart@bugs.koha-community.org">jonathan.druart@bugs.koha-community.org</a>>) escribió:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>yes could be NULL instead.<br></div>(date calculation perf issue is fixed)<br></div><br><div class="gmail_quote"><div dir="ltr">On Wed, 14 Feb 2018 at 12:50 Marcel de Rooy <<a href="mailto:M.de.Rooy@rijksmuseum.nl" target="_blank">M.de.Rooy@rijksmuseum.nl</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div id="m_-6024023803210962973m_5450365728659515439divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif" dir="ltr">
<p style="margin-top:0px;margin-bottom:0px">Sounds to me like NULL was meant ?<br>
</p>
<p>Using 9999-12-31 resulted in expensive date calculations previously.</p>
<p><br>
<br>
</p>
<div style="color:rgb(0,0,0)">
<hr style="width:98%;display:inline-block">
<div id="m_-6024023803210962973m_5450365728659515439divRplyFwdMsg" dir="ltr"><font color="#000000" face="Calibri, sans-serif" style="font-size:11pt"><b>Van:</b> <a href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">koha-devel-bounces@lists.koha-community.org</a> <<a href="mailto:koha-devel-bounces@lists.koha-community.org" target="_blank">koha-devel-bounces@lists.koha-community.org</a>> namens Jonathan Druart <<a href="mailto:jonathan.druart@bugs.koha-community.org" target="_blank">jonathan.druart@bugs.koha-community.org</a>><br>
<b>Verzonden:</b> woensdag 14 februari 2018 16:41<br>
<b>Aan:</b> <a href="mailto:koha-devel@lists.koha-community.org" target="_blank">koha-devel@lists.koha-community.org</a><br>
<b>Onderwerp:</b> Re: [Koha-devel] 0000-00-00 is expired?</font>
<div> </div>
</div></div></div></div><div dir="ltr"><div id="m_-6024023803210962973m_5450365728659515439divtagdefaultwrapper" style="font-size:12pt;color:#000000;font-family:Calibri,Helvetica,sans-serif" dir="ltr"><div style="color:rgb(0,0,0)">
<div>
<div dir="ltr">
<div>Great news then :)<br>
<br>
</div>
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"?<br>
<br>
<div class="m_-6024023803210962973m_5450365728659515439x_gmail_quote">
<div dir="ltr">On Wed, 14 Feb 2018 at 12:13 Tomas Cohen Arazi <<a href="mailto:tomascohen@gmail.com" target="_blank">tomascohen@gmail.com</a>> wrote:<br>
</div>
<blockquote class="m_-6024023803210962973m_5450365728659515439x_gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
<div dir="ltr">In all my 65 instances, there's not '0000-00-00'. This is probably a data migration issue.</div>
<br>
<div class="m_-6024023803210962973m_5450365728659515439x_gmail_quote">
<div dir="ltr">El mié., 14 feb. 2018 a las 11:05, Sophie Meynieux (<<a href="mailto:sophie.meynieux@biblibre.com" target="_blank">sophie.meynieux@biblibre.com</a>>) escribió:<br>
</div>
<blockquote class="m_-6024023803210962973m_5450365728659515439x_gmail_quote" style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid">
<div bgcolor="#FFFFFF">
<p>Hello,</p>
<p>For all our customers that are hosted on our servers, only one has one patron with dateexpiry = "0000-00-00"</p>
<p>Regards</p>
<p>S. Meynieux<br>
</p>
</div>
<div bgcolor="#FFFFFF">
<pre class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-signature" cols="72">--
Responsable support
BibLibre
<a href="tel:+33%204%2091%2081%2035%2008" value="+33491813508" target="_blank">+ 33 (0)4 91 81 35 08</a>
<a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://www.biblibre.com" target="_blank">http://www.biblibre.com</a></pre>
</div>
<div bgcolor="#FFFFFF">
<div class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-cite-prefix">Le 14/02/2018 à 12:12, Katrin Fischer a écrit :<br>
</div>
<blockquote type="cite">
<div style="font-family:Verdana;font-size:12px">
<div>
<div>I've also checked our oldest 5 - didn't find any patrons with dateexpiry 0000-00-00.</div>
<div>
<div style="margin:10px 5px 5px 10px;padding:10px 0px 10px 10px;border-left-color:rgb(195,217,229);border-left-width:2px;border-left-style:solid" name="x_quote">
<div style="margin:0px 0px 10px"><b>Gesendet:</b> Mittwoch, 14. Februar 2018 um 08:18 Uhr<br>
<b>Von:</b> "Magnus Enger" <a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-rfc2396E" href="mailto:magnus@enger.priv.no" target="_blank">
<magnus@enger.priv.no></a><br>
<b>An:</b> <a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-abbreviated" href="mailto:koha-devel@lists.koha-community.org" target="_blank">koha-devel@lists.koha-community.org</a><br>
<b>Betreff:</b> Re: [Koha-devel] 0000-00-00 is expired?</div>
<div name="x_quoted-content">Hiya!<br>
<br>
On 13 February 2018 at 20:06, Jonathan Druart<br>
<a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-rfc2396E" href="mailto:jonathan.druart@bugs.koha-community.org" target="_blank"><jonathan.druart@bugs.koha-community.org></a> wrote:<br>
> It would be useful to know the return of<br>
> SELECT COUNT(*) FROM borrowers where dateexpiry="0000-00-00"<br>
> on old installations.<br>
<br>
I just checked my 5 oldest instances (upgraded regularly since<br>
2009/2010) and none of them had any users meeting this criterium.<br>
<br>
Best regards,<br>
Magnus<br>
Libriotech<br>
_______________________________________________<br>
Koha-devel mailing list<br>
<a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109mimeAttachmentHeader">
</fieldset> <br>
<pre>_______________________________________________
Koha-devel mailing list
<a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-abbreviated" href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a>
<a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></pre>
</blockquote>
<br>
</div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">
http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">
http://bugs.koha-community.org/</a></blockquote>
</div>
-- <br>
<div class="m_-6024023803210962973m_5450365728659515439x_m_6511799411174690008gmail_signature" dir="ltr">
<div dir="ltr">
<div style="color:rgb(117,117,117);font-family:"helvetica neue",helvetica,arial,sans-serif;font-size:12.8px">
Tomás Cohen Arazi</div>
<div style="color:rgb(117,117,117);font-family:"helvetica neue",helvetica,arial,sans-serif;font-size:12.8px">
Theke Solutions (<a href="http://theke.io/" target="_blank">https://theke.io</a>)<br>
✆ <a href="tel:+54%209%20351%20351-3384" value="+5493513513384" target="_blank">+54 9351 3513384</a><br>
GPG: B2F3C15F</div>
</div>
</div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">
http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">
http://bugs.koha-community.org/</a></blockquote>
</div>
</div>
</div>
</div></div></div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a></blockquote></div>
_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" rel="noreferrer" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" rel="noreferrer" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" rel="noreferrer" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" rel="noreferrer" target="_blank">http://bugs.koha-community.org/</a></blockquote></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div style="color:rgb(117,117,117);font-family:"helvetica neue",helvetica,arial,sans-serif;font-size:12.8px">Tomás Cohen Arazi</div><div style="color:rgb(117,117,117);font-family:"helvetica neue",helvetica,arial,sans-serif;font-size:12.8px">Theke Solutions (<a href="http://theke.io/">https://theke.io</a>)<br>✆ +54 9351 3513384<br>GPG: B2F3C15F</div></div></div>