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

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: hans(at)matfyz(dot)cz
Subject: What does the value 5874897 AD mean? Which year, month, day, please?
Date: 2019-02-07 12:11:05
Message-ID: 154954146564.1294.13684654750312708212@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2019-02-07 14:31:13 Typo in Table 8.7 bytea Literal Escaped Octets
Previous Message Peter Eisentraut 2019-02-07 11:06:14 Re: First SVG graphic