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: <[email protected]<mailto:[email protected]>> on behalf of Florent Georges <[email protected]<mailto:[email protected]>> Reply-To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Date: Friday, July 22, 2016 at 7:36 AM To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> 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: <[email protected]<mailto:[email protected]>> on behalf of Florent Georges <[email protected]<mailto:[email protected]>> Reply-To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> Date: Thursday, July 21, 2016 at 5:07 PM To: MarkLogic Developer Discussion <[email protected]<mailto:[email protected]>> 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 [email protected]<mailto:[email protected]> Manage your subscription at: 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 [email protected] Manage your subscription at: http://developer.marklogic.com/mailman/listinfo/general
