From: | "Watzinger, Alexander" <Alexander(dot)Watzinger(at)oeaw(dot)ac(dot)at> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Support for dates before 4713 BC |
Date: | 2022-08-20 14:05:42 |
Message-ID: | ca438ff8331c4e109aa1b75a130948ac@oeaw.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
I'm working on the open source project OpenAtlas (https://openatlas.eu) which is used to enter historical and archeological data.
Although we really appreciate the wonderful PostgreSQL software, the limitation of not being able to use dates before 4713 BC is problematic in regard to archeological data.
The only reason for this limitation I found was that the Julian Calendar wasn't created with this in mind. The only suggestion I found was to write an own implementation just using integers for years. But building a parallel date system in this case would be way to cumbersome and error prone, we really like using the database for date operations.
So my questions are:
Any chance to add support for dates before 4713 BC? We really would appreciate that.
The 4713 BC limit feels very arbitrary, what is the reason for this exact limit?
Feedback and pointers are very welcome,
Alex
--
Alexander Watzinger
Austrian Academy of Sciences
Austrian Centre for Digital Humanities and Cultural Heritage
alexander(dot)watzinger(at)oeaw(dot)ac(dot)at | www.oeaw.ac.at/acdh
From | Date | Subject | |
---|---|---|---|
Next Message | Perry Smith | 2022-08-20 22:42:27 | With Recursive / Recursive View question |
Previous Message | Jeremy Schneider | 2022-08-19 23:31:54 | Re: Monitoring multixact members growth |