Обсуждение: What does the value 5874897 AD mean? Which year, month, day, please?

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/datatype-datetime.html
Description:

See also
https://stackoverflow.com/questions/29434748/what-does-bc-date-mean-in-postgresql.

Add a note about how the date/timestamp is internally represented, please.
E.g.
https://docs.teradata.com/reader/S0Fw2AVH8ff3MDA0wDOHlQ/dkWLOva_L12uKvSnUcJQsQ.

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