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
Responses Re: Working with dates before 4713 BC
List pgsql-sql

Hi all,

 

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).

 

Does anyone have any suggestions for making these dates play nicely with items created more recently (January 10th, 1968 for example)? My only other requirement is that I need to be able to execute SQL queries which can find items made before a certain date, after a certain date, or between two dates.

 

Cheers,

Ryan

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