From: Watzinger, Alexander <Alexander.Watzinger@oeaw.ac.at>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Support for dates before 4713 BC
Date: Sat, 20 Aug 2022 14:05:42 +0000
Message-ID: <ca438ff8331c4e109aa1b75a130948ac@oeaw.ac.at> (raw)
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.watzinger@oeaw.ac.at | www.oeaw.ac.at/acdh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: Alexander.Watzinger@oeaw.ac.at, pgsql-general@lists.postgresql.org
Subject: Re: Support for dates before 4713 BC
In-Reply-To: <ca438ff8331c4e109aa1b75a130948ac@oeaw.ac.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox