Re: to_date 'J' format misunderstanding

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: to_date 'J' format misunderstanding
Дата
Msg-id 57126AD3.1090406@gmx.net
обсуждение исходный текст
Ответ на to_date 'J' format misunderstanding  (Alex Ignatov <a.ignatov@postgrespro.ru>)
Список 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.



В списке pgsql-docs по дате отправления: