public inbox for [email protected]  

help / color / mirror / Atom feed

From: Alex Ignatov <[email protected]>
To: [email protected]
Subject: to_date 'J' format misunderstanding
Date: Wed, 9 Mar 2016 14:42:43 +0300
Message-ID: <[email protected]> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: to_date 'J' format misunderstanding
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox