• Tom Lane's avatar
    Doc: document EXTRACT(JULIAN ...), improve Julian Date explanation. · 79a5928e
    Tom Lane authored
    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
    79a5928e
datetime.sgml 32.4 KB