Working with dates before 4713 BC - Mailing list pgsql-sql

From Ryan Wallace
Subject Working with dates before 4713 BC
Date
Msg-id 002a01c8af0f$4728b700$d57a2500$@ubc.ca
Whole thread Raw
Responses Re: Working with dates before 4713 BC  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
<div class="Section1"><p class="MsoNormal">Hi all,<p class="MsoNormal"> <p class="MsoNormal">I am building an
applicationwhich requires the storage of dates relating to the creation of archaeological items. The problem I am
facingis that although most of the dates are working fine, some of the items were created before the beginning of
recordedhistory (4713 BC). <p class="MsoNormal"> <p class="MsoNormal">Does anyone have any suggestions for making these
datesplay nicely with items created more recently (January 10<sup>th</sup>, 1968 for example)? My only other
requirementis that I need to be able to execute SQL queries which can find items made before a certain date, after a
certaindate, or between two dates.<p class="MsoNormal"> <p class="MsoNormal">Cheers,<p class="MsoNormal">Ryan</div> 

pgsql-sql by date:

Previous
From: Frank Bax
Date:
Subject: Re: LEFT OUTER JOIN question
Next
From: Tom Lane
Date:
Subject: Re: Working with dates before 4713 BC