Support for dates before 4713 BC

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

Responses

Browse pgsql-general by date

  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