Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1arTGH-0007Ik-BW for pgsql-docs@arkaria.postgresql.org; Sat, 16 Apr 2016 16:39:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1arTGG-00063E-NE for pgsql-docs@arkaria.postgresql.org; Sat, 16 Apr 2016 16:39:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1arTGG-00062n-0U for pgsql-docs@postgresql.org; Sat, 16 Apr 2016 16:39:56 +0000 Received: from mout.gmx.net ([212.227.17.22]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84_2) (envelope-from ) id 1arTGC-0008IL-FS for pgsql-docs@postgresql.org; Sat, 16 Apr 2016 16:39:55 +0000 Received: from auth1-smtp.messagingengine.com ([66.111.4.227]) by mail.gmx.com (mrgmx102) with ESMTPSA (Nemesis) id 0MY4Ls-1bDNpe20Ia-00Uvw3 for ; Sat, 16 Apr 2016 18:39:50 +0200 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailauth.nyi.internal (Postfix) with ESMTP id ECF5721A1D for ; Sat, 16 Apr 2016 12:39:48 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute5.internal (MEProxy); Sat, 16 Apr 2016 12:39:48 -0400 X-Sasl-enc: etfskMCExfZDk8T1zRR682FokPTx/hU06Seb2HYReYY6 1460824788 Received: from vanquo.pezone.net (c-73-13-66-39.hsd1.pa.comcast.net [73.13.66.39]) by mail.messagingengine.com (Postfix) with ESMTPA id AAAE7C00012; Sat, 16 Apr 2016 12:39:48 -0400 (EDT) Subject: Re: to_date 'J' format misunderstanding To: Alex Ignatov , pgsql-docs@postgresql.org References: <56E00C33.3080502@postgrespro.ru> From: Peter Eisentraut Message-ID: <57126AD3.1090406@gmx.net> Date: Sat, 16 Apr 2016 12:39:47 -0400 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:38.0) Gecko/20100101 Icedove/38.6.0 MIME-Version: 1.0 In-Reply-To: <56E00C33.3080502@postgrespro.ru> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Provags-ID: V03:K0:xqgizVUZtf1mgxfe1cPTkfFSjo7sepu2hsOEdhfI6RQ737wO3iO wP3dqzasUQoo0BLNrZkgnHL4HTKH+U3BPEdcTg1kI+KGYZSsezPImi+SRHQiEXQ5FZyrwdR Qptx5emZT3XQo2vly6T/Nw71l6dwfOCEwvUgCZUnt/TMLzyjPQF1sX4gVnaAjd96dmuRz1n 2E1QSvF+IW7oyzJpsRhXw== X-UI-Out-Filterresults: notjunk:1;V01:K0:ZCdg1Hb7nTc=:YgOpKFmQ4kb6AjSwwiuEb5 m2oX5y0DOWPmQDVzhQXzvehj37PXFTzQx1KWUSNuvayNvUCbeLwVHn8a6DG619Lq8FbTpYg9W RDbYMYXSiT6RvfofT0tpwOaPSWAFNJar++/kMm3O/ju6hSpvQmrsH2QoAJSTC43+8s2xhZTja R/dSnDDniKWRBax1pfVDyZcl6nB4Mmf/6sXLaMrapbXTdbHo6447vjtIP8ZSUSYpThztSpHPk LuqfbjF6wNKtizOHWDuziZLm29dHiJsHboU2AIMneoXkyU1873iCzl2PMxWLq/1zraZszbBk5 EOVMeDrCw4Mr890+tIsRHofaXvhI/vb0WvrGlnoE9t6ZckRYErOtr8psHa8Fe4ux2+v8WF7XK idHnlWIMIrfdPW/suLqPTqt1cl58ggCUUueMW0HXIy/D9sOk4xdCpvsMXsyIMv61ngc0+dFjh Qg5/Lto/xWuPR5D56Km1Hvyx1Y1gt45VCX9IKGJoXhtUvCS5HjOP52BJbdoFBwIVdAnopf5ke RHXBlpFEukn8wHYQnHJH+ufTSvXL2if7r/Gu4jgKSRTPAjASiMp56bWYJjXXkIHfgI3VzzDO8 nX14II6NyR4oRExl9PFHYEhKLZQPiKjSVJRt2LiFh+mFOBx3sWvr0o9tg5vVKNwcjBcReNHeJ wG5f+QrDwrVDiG9bvcaBVIi+GxSctQbr4uaH7l9H7KPARqKOiA5up5zlNIxPKVEn35ZK7eEDk 81KuCXkDcsj6NEItjyXLpCH3niXGcWRcmf9/pRPjOHR10BRCE0hqWE8p3YJzfS27eSLYjB9vS bX/5YNh X-Pg-Spam-Score: -3.6 (---) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On 03/09/2016 06:42 AM, Alex Ignatov wrote: > In Table 9-22. Template Patterns for Date/Time Formatting we have > > 'J Julian Day (days since November 24, 4714 BC at midnight)' > > But there is no any information about what calender use for date of > November 24, 4714 BC. From wikipedia we know that it is > November 24, 4714 BC, in the proleptic Gregorian calendar. I don't think we need to overdocument this. The Julian Day is defined outside of PostgreSQL, and those who are considering using it will know about these kinds of details. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs