Skip site navigation (1) Skip section navigation (2)

Working with dates before 4713 BC

From: Ryan Wallace <rywall(at)interchange(dot)ubc(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Working with dates before 4713 BC
Date: 2008-05-06 00:22:29
Message-ID: 002a01c8af0f$4728b700$d57a2500$@ubc.ca (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-sql by date

Next:From: Tom LaneDate: 2008-05-06 01:17:24
Subject: Re: Working with dates before 4713 BC
Previous:From: Frank BaxDate: 2008-05-04 16:54:29
Subject: Re: LEFT OUTER JOIN question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group