Hey, good catch! Thank you, Geert. -- Florent Georges http://fgeorges.org/ http://h2oconsulting.be/
On 22 July 2016 at 08:04, Geert Josten wrote: > Hi Florent, > > I looked for the XML Schema definition, and found this: > > [-]CCYY-MM-DDThh:mm:ss[Z|(+|-)hh:mm] > > > On amongst others: http://books.xmlschemata.org/relaxng/ch19-77049.html > > -9999 is also accepted by MarkLogic.. > > But thinking about it a little more, -9999-12-31 is not that lowest > possible value. January still comes before December, and MarkLogic seems to > confirm: > > xs:dateTime("-9999-12-31T23:59:59Z") gt > xs:dateTime("-9999-01-01T00:00:00Z”) > > —> true > > So, closest to minus infinity would be: "-9999-01-01T00:00:00Z” > > Cheers, > Geert > > From: <general-boun...@developer.marklogic.com> on behalf of Florent > Georges <li...@fgeorges.org> > Reply-To: MarkLogic Developer Discussion <general@developer.marklogic.com> > Date: Friday, July 22, 2016 at 7:36 AM > To: MarkLogic Developer Discussion <general@developer.marklogic.com> > Subject: Re: [MarkLogic Dev General] Bitemporal: minus infinity > > Hi Geert, > > Well, I don't know, hence my question :-) Before posting, we discussed this > with a few colleagues and 3 possibilities emerged: > > - 0000-01-01T00:00:00Z > - 0001-01-01T00:00:00Z > - -9999-12-31T23:59:59Z > > But we were only guessing. ISO 8601 is not quite definitive about > boundaries > for the year component <https://en.wikipedia.org/wiki/ISO_8601#Years>. I > felt > that: > > - there might be a time which is handled specifically by MarkLogic (for > comparisons, in the indexes, etc.) > - there must be limitations about the earliest time representable, but I > could > not find them documented > > Regards, > > -- > Florent Georges > http://fgeorges.org/ > http://h2oconsulting.be/ > > > On 22 July 2016 at 07:18, Geert Josten wrote: > >> How about “-9999-12-31T23:59:59Z”? >> >> Cheers, >> Geert >> >> From: <general-boun...@developer.marklogic.com> on behalf of Florent >> Georges <li...@fgeorges.org> >> Reply-To: MarkLogic Developer Discussion <general@developer.marklogic.com >> > >> Date: Thursday, July 21, 2016 at 5:07 PM >> To: MarkLogic Developer Discussion <general@developer.marklogic.com> >> Subject: [MarkLogic Dev General] Bitemporal: minus infinity >> >> Hi, >> >> The bitemporal documentation mentions "infinity" several times, and says >> we must use "9999-12-31T23:59:59Z" for that purpose. >> >> But as far as I can tell, it does not say anything about what to use for >> "minus inifnity". >> >> Regards, >> >> -- >> Florent Georges >> http://fgeorges.org/ >> http://h2oconsulting.be/ >> >> >> _______________________________________________ >> General mailing list >> General@developer.marklogic.com >> Manage your subscription at: >> http://developer.marklogic.com/mailman/listinfo/general >> >> -- >> <http://developer.marklogic.com/mailman/listinfo/general> >> Florent Georges >> <http://developer.marklogic.com/mailman/listinfo/general> >> http://fgeorges.org/ >> http://h2oconsulting.be/ >> >> > _______________________________________________ > General mailing list > General@developer.marklogic.com > Manage your subscription at: > http://developer.marklogic.com/mailman/listinfo/general > >
_______________________________________________ General mailing list General@developer.marklogic.com Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general