To: pgsql-docs@postgresql.org
From: Alex Ignatov <a.ignatov@postgrespro.ru>
Subject: to_date 'J' format misunderstanding
Message-ID: <56E00C33.3080502@postgrespro.ru>
Date: Wed, 9 Mar 2016 14:42:43 +0300
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:38.0) Gecko/20100101
 Thunderbird/38.6.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

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 think information about Gregorian calendar must include in 
documentation for misunderstaning exclusion

PS. In oracle docs we have following info about formatting:

' J Yes Julian day; the number of days since January 1, 4712 BC. Number 
specified with J must be integers.'

again no any information about what calendar is using for  date January 
1, 4712 BC  %)

-- 
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs