Re: Support for dates before 4713 BC

Hi Nina Richards, Instead of using PostgreSQL's DATE or TIMESTAMP types, you can store years as NUMERIC or BIGINT values. You can manually represent dates before 4713 BC and build custom functions for date operations like addition, subtraction, or comparison. To facilitate comparisons or operatio

Re: Support for dates before 4713 BC

David Rowley writes: > It's by no means a trivial thing to do, but it is possible to > implement new types in PostgreSQL [1]. If you invented your own type, > you could significantly widen the upper and lower bounds when compared > with the standard date type. However, you'd then have to reimplem

Re: Support for dates before 4713 BC

On Thu, 17 Oct 2024 at 01:26, Richards, Nina wrote: > Even though we know there was no calendar at that time, it would make our > work much easier if we could use data before 4713 BC in the same way. > Especially for statistical analyses and scientific dating methods (14C, > dendrochronology),

Re: Support for dates before 4713 BC

Dear all, As Alex, I'm involved with the OpenAtlas system (https://openatlas.eu), and in a recent meeting the issue about tracking dates before 4713 BC came up again. We appreciate all the work you put into developing PostgreSQL and love working with it. But as already mentioned in the discuss

Sv: Support for dates before 4713 BC

På mandag 04. mars 2024 kl. 17:01:46, skrev Koschicek-Krombholz, Bernhard < bernhard.koschicek-krombh...@oeaw.ac.at >: It would be very useful if PostgreSQL would support dates before 4713 BC. Out of curiosity, are there any plans to implement it

Support for dates before 4713 BC

It would be very useful if PostgreSQL would support dates before 4713 BC. Out of curiosity, are there any plans to implement it in the near future? All the best, Bernhard Koschicek-Krombholz

Re: Support for dates before 4713 BC

Simon Riggs writes: > On Mon, 12 Sept 2022 at 16:00, Tom Lane wrote: >> No, it applies because we aren't sure that the math would operate >> correctly with negative Julian day numbers --- for instance, division >> roundoffs might happen in the wrong direction. If somebody wanted to go >> through

Re: Support for dates before 4713 BC

On Mon, 12 Sept 2022 at 16:00, Tom Lane wrote: > > Simon Riggs writes: > > On Sun, 21 Aug 2022 at 19:04, Tom Lane wrote: > >> There are existing equations for calculating Gregorian month/day/year from > >> Julian day count [1]. They work back to Julian day zero, at least if > >> you grant that

Re: Support for dates before 4713 BC

Simon Riggs writes: > On Sun, 21 Aug 2022 at 19:04, Tom Lane wrote: >> There are existing equations for calculating Gregorian month/day/year from >> Julian day count [1]. They work back to Julian day zero, at least if >> you grant that proleptic Gregorian dates are sensible that far back. >> Nob

Re: Support for dates before 4713 BC

On Sun, 21 Aug 2022 at 19:04, Tom Lane wrote: > > "Watzinger, Alexander" writes: > > Any chance to add support for dates before 4713 BC? We really would > > appreciate that. > > I'm a little skeptical of the value of applying the Gregorian calendar > be

Re: Support for dates before 4713 BC

Bäckerstraße 13, 1010 Vienna, Austria alexander.watzin...@oeaw.ac.at | www.oeaw.ac.at/acdh From: Adrian Klaver Sent: Sunday, August 21, 2022 19:15 To: Watzinger, Alexander; pgsql-general@lists.postgresql.org Subject: Re: Support for dates before 4713 BC On 8/20/22 07

Re: Support for dates before 4713 BC

> On 23/08/2022 14:38 CEST Peter J. Holzer wrote: > > > On 2022-08-23 10:25:12 +0100, Simon Riggs wrote: > > On Mon, 22 Aug 2022 at 11:14, stefan eichert > > wrote: > > > In order to deal with all dates, historical and prehistoric ones, in > > > a consistent way, the implementation of times

Re: Support for dates before 4713 BC

On 2022-08-23 10:25:12 +0100, Simon Riggs wrote: > On Mon, 22 Aug 2022 at 11:14, stefan eichert wrote: > > In order to deal with all dates, historical and prehistoric ones, in > > a consistent way, the implementation of timestamps/dates for before > > 4713 BC would be very helpful, as we really do

Re: Support for dates before 4713 BC

On Mon, 22 Aug 2022 at 11:14, stefan eichert wrote: > I can also fully support what Alex has written. I am an archaeologist at the > Natural History Museum Vienna and PostgreSQL is a perfect Open Source > software and we really love working with it for our archaeological and > (pre)historical

Re: Support for dates before 4713 BC

This is a bit off topic, but Raku, the sister language of Perl, has a built-in Date object that should be able to handle the situation. I wonder if there is a possibility of someday having an interface with Raku as with Perl. Note Raku has an excellent module to use PostgreSQL. Blessings. -Tom

Re: Support for dates before 4713 BC

Hello Stefan, Alexander, On 2022-Aug-22, stefan eichert wrote: > I can also fully support what Alex has written. I am an archaeologist at > the Natural History Museum Vienna and PostgreSQL is a perfect Open Source > software and we really love working with it for our archaeological and > (pre)his

Re: Support for dates before 4713 BC

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 re

Re: Support for dates before 4713 BC

"Watzinger, Alexander" writes: > Any chance to add support for dates before 4713 BC? We really would > appreciate that. I'm a little skeptical of the value of applying the Gregorian calendar before 1582 AD, let alone thousands of years before the Romans invented anything

Re: Support for dates before 4713 BC

> 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

Re: Support for dates before 4713 BC

s for years. But building a parallel date system in this case would be way to cumbersomeand 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

Support for dates before 4713 BC

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 pointer