public inbox for [email protected]  

help / color / mirror / Atom feed

to_date 'J' format misunderstanding
2+ messages / 2 participants
[nested] [flat]

* to_date 'J' format misunderstanding
@ 2016-03-09 11:42  Alex Ignatov <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Alex Ignatov @ 2016-03-09 11:42 UTC (permalink / raw)
  To: pgsql-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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: to_date 'J' format misunderstanding
@ 2016-04-16 16:39  Peter Eisentraut <[email protected]>
  parent: Alex Ignatov <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Eisentraut @ 2016-04-16 16:39 UTC (permalink / raw)
  To: Alex Ignatov <[email protected]>; pgsql-docs

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2016-04-16 16:39 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-03-09 11:42 to_date 'J' format misunderstanding Alex Ignatov <[email protected]>
2016-04-16 16:39 ` Peter Eisentraut <[email protected]>

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