RE: What does the value 5874897 AD mean? Which year, month, day,please? - Mailing list pgsql-docs

From Vianello, Daniel A
Subject RE: What does the value 5874897 AD mean? Which year, month, day,please?
Date
Msg-id 2ba5f73f6de84b23bd66c183462a4acf@NCEMEXGP001.CORP.CHARTERCOM.com
Whole thread Raw
In response to What does the value 5874897 AD mean? Which year, month, day, please?  (PG Doc comments form <noreply@postgresql.org>)
List 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 by date:

Previous
From: PG Doc comments form
Date:
Subject: Typo in Table 8.7 bytea Literal Escaped Octets
Next
From: Jürgen Purtz
Date:
Subject: Re: First SVG graphic