From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Ryan Wallace <rywall(at)interchange(dot)ubc(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Working with dates before 4713 BC |
Date: | 2008-05-06 01:17:24 |
Message-ID: | 6047.1210036644@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Ryan Wallace <rywall(at)interchange(dot)ubc(dot)ca> writes:
> I am building an application which requires the storage of dates relating to
> the creation of archaeological items. The problem I am facing is that
> although most of the dates are working fine, some of the items were created
> before the beginning of recorded history (4713 BC).
The existing date/timestamp code has no chance of dealing with that,
I'm afraid --- I doubt the code is likely to work for negative Julian
dates. Its underlying assumptions are pretty much fantasy anyway,
that far back. Nobody was using the Gregorian calendar then ...
Do you really need microsecond, or even day, resolution in your dates?
I wonder if it'd not be good enough to store the year as an integer.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Phillip Smith | 2008-05-06 01:28:49 | Re: Working with dates before 4713 BC |
Previous Message | Ryan Wallace | 2008-05-06 00:22:29 | Working with dates before 4713 BC |