Re: to_date 'J' format misunderstanding

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: 57126AD3.1090406@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2016-04-16 16:56:39 Re: s/user/role/ in section 5.6 of v9.5.0 and 9.6devel of docs.
Previous Message Peter Eisentraut 2016-04-16 01:12:22 Re: [PATCH] Clarify semantics of restore_command exit status