Lists: | pgsql-docs |
---|
From: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | to_date 'J' format misunderstanding |
Date: | 2016-03-09 11:42:43 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | 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
From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>, pgsql-docs(at)postgresql(dot)org |
Subject: | Re: to_date 'J' format misunderstanding |
Date: | 2016-04-16 16:39:47 |
Message-ID: | [email protected] |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Lists: | 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.