Doc: document EXTRACT(JULIAN ...), improve Julian Date explanation.
Tom Lane <tgl@sss.pgh.pa.us>
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
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/datetime.sgml | modified | +40 −6 |
| doc/src/sgml/func.sgml | modified | +21 −1 |
Documentation touched
Discussion
- Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 47 messages · 2019-11-30 → 2021-06-08