Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id F0A72FBD25B for ; Thu, 26 Apr 2012 18:15:33 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SNW2H-000468-7o for pgsql-docs@postgresql.org; Thu, 26 Apr 2012 21:15:33 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q3QLFJa6014470; Thu, 26 Apr 2012 17:15:19 -0400 (EDT) To: Robert Haas cc: Kevin Grittner , cousinflo@free.fr, pgsql-docs@postgresql.org Subject: Re: Date/Time Types : internals In-reply-to: <11541.1335465978@sss.pgh.pa.us> References: <4F8F0F71.20500@free.fr> <4F8ED21402000025000470FA@gw.wicourts.gov> <9773.1334780084@sss.pgh.pa.us> <11541.1335465978@sss.pgh.pa.us> Comments: In-reply-to Tom Lane message dated "Thu, 26 Apr 2012 14:46:18 -0400" Date: Thu, 26 Apr 2012 17:15:19 -0400 Message-ID: <14469.1335474919@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/56 X-Sequence-Number: 7310 I wrote: > Robert Haas writes: >> So which calendar are we using, Julian or Gregorian? > Gregorian. I fail to see anyplace that suggests we use the Julian > calendar. We do understand the Julian date system, which is something > entirely different with a confusingly similar name. (Julian dates are > just a count of days since a reference point in 4713 BC.) On further reflection I wonder whether we shouldn't just get rid of "8.5.6. Internals", which is at best rather inappropriately placed. A person reading this portion of the docs probably couldn't care less whether we use Julian-date calculations internally. It might be appropriate to mention that in appendix B.4, where there's an actual explanation of what Julian dates are; but not here. What I think we should have here is an externally-facing specification, that is state that we follow the Gregorian calendar rules even for years before Pope Gregory's edict, and then reference B.4 for more info. regards, tom lane