Working with dates before 4713 BC

Поиск
Список
Период
Сортировка
От Ryan Wallace
Тема Working with dates before 4713 BC
Дата
Msg-id 002a01c8af0f$4728b700$d57a2500$@ubc.ca
обсуждение исходный текст
Ответы Re: Working with dates before 4713 BC  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Frank Bax
Дата:
Сообщение: Re: LEFT OUTER JOIN question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Working with dates before 4713 BC