RE: What does the value 5874897 AD mean? Which year, month, day,please?

Поиск
Список
Период
Сортировка
От Vianello, Daniel A
Тема RE: What does the value 5874897 AD mean? Which year, month, day,please?
Дата
Msg-id 2ba5f73f6de84b23bd66c183462a4acf@NCEMEXGP001.CORP.CHARTERCOM.com
обсуждение исходный текст
Ответ на What does the value 5874897 AD mean? Which year, month, day, please?  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
> What does the value 5874897 AD mean? Which year, month, day, please?

The maximum allowed date (not timestamp) is Dec 31st in the year 5874897, which you can test with the query: select
'5874897-12-31'::date;and select '5874897-12-31'::date + interval '1 day'; The latter query fails with "Error: date out
ofrange for timestamp".  
 

I logged nearly this same response for you on StackOverflow, too.

E-MAIL CONFIDENTIALITY NOTICE: 
The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain
confidentialand/or legally privileged information. If you are not the intended recipient of this message or if this
messagehas been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this
messageand any attachments. If you are not the intended recipient, you are notified that any use, dissemination,
distribution,copying, or storage of this message or any attachment is strictly prohibited. 

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Typo in Table 8.7 bytea Literal Escaped Octets
Следующее
От: Jürgen Purtz
Дата:
Сообщение: Re: First SVG graphic