<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" 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 tabindex="-1" style="width: 98%; display: inline-block;">
<div id="divRplyFwdMsg" dir="ltr"><font color="#000000" face="Calibri, sans-serif" style="font-size: 11pt;"><b>Van:</b> koha-devel-bounces@lists.koha-community.org <koha-devel-bounces@lists.koha-community.org> namens Jonathan Druart <jonathan.druart@bugs.koha-community.org><br>
<b>Verzonden:</b> woensdag 14 februari 2018 16:41<br>
<b>Aan:</b> koha-devel@lists.koha-community.org<br>
<b>Onderwerp:</b> Re: [Koha-devel] 0000-00-00 is expired?</font>
<div> </div>
</div>
<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="x_gmail_quote">
<div dir="ltr">On Wed, 14 Feb 2018 at 12:13 Tomas Cohen Arazi <<a href="mailto:tomascohen@gmail.com">tomascohen@gmail.com</a>> wrote:<br>
</div>
<blockquote class="x_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="x_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="x_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="x_m_6511799411174690008m_-7264670924409742109moz-signature" cols="72">--
Responsable support
BibLibre
<a href="tel:+33%204%2091%2081%2035%2008" target="_blank" value="+33491813508">+ 33 (0)4 91 81 35 08</a>
<a class="x_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="x_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; -ms-word-wrap: break-word;" 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="x_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="x_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="x_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="x_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="x_m_6511799411174690008m_-7264670924409742109mimeAttachmentHeader">
</fieldset> <br>
<pre>_______________________________________________
Koha-devel mailing list
<a class="x_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="x_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="x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a class="x_m_6511799411174690008m_-7264670924409742109moz-txt-link-freetext" href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a class="x_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" target="_blank" rel="noreferrer">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank" rel="noreferrer">
http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank" rel="noreferrer">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank" rel="noreferrer">
http://bugs.koha-community.org/</a></blockquote>
</div>
-- <br>
<div class="x_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" target="_blank" value="+5493513513384">+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" target="_blank" rel="noreferrer">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank" rel="noreferrer">
http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank" rel="noreferrer">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank" rel="noreferrer">
http://bugs.koha-community.org/</a></blockquote>
</div>
</div>
</div>
</div>
</div>
</body>
</html>