Обсуждение: pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati

Поиск
Список
Период
Сортировка

pgsql: Doc: document EXTRACT(JULIAN ...), improve Julian Date explanati

От
Tom Lane
Дата:
Doc: document EXTRACT(JULIAN ...), improve Julian Date explanation.

For some reason, the "julian" option for extract()/date_part() has
never gotten listed in the manual.  Also, while Appendix B mentioned
in passing that we don't conform to the usual astronomical definition
that a Julian date starts at noon UTC, it was kind of vague about what
we do instead.  Clarify that, and add an example showing how to get
the astronomical definition if you want it.

It's been like this for ages, so back-patch to all supported branches.

Discussion: https://postgr.es/m/1197050.1619123213@sss.pgh.pa.us

Branch
------
REL9_6_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b391db4943dce0688635b9e6550af22a4dac96ed

Modified Files
--------------
doc/src/sgml/datetime.sgml | 46 ++++++++++++++++++++++++++++++++++++++++------
doc/src/sgml/func.sgml     | 22 +++++++++++++++++++++-
2 files changed, 61 insertions(+), 7 deletions(-)