Re: Calendar support in localization

Поиск
Список
Период
Сортировка
От Matthias van de Meent
Тема Re: Calendar support in localization
Дата
Msg-id CAEze2Wi+-WCYLkERKJgg+wB1BQ0WOXCw6u8dykS4UTB--3xBVQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Calendar support in localization  ("Daniel Verite" <daniel@manitou-mail.org>)
Ответы Re: Calendar support in localization  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-hackers
On Fri, 26 Mar 2021 at 18:51, Daniel Verite <daniel@manitou-mail.org> wrote:
> [...]
> -[ RECORD 2 ]--+-------------------------------------------------------
> cal            | japanese
> now_str        | 26/mars/0033 Heisei 18:22:07.566 UTC+1
> now_parsed     | 2021-03-26 18:22:07.566+01
> plus_1m        | 26/avril/0033 Heisei 18:22:07.566 UTC+2
> plus_1m_parsed | 2021-04-26 18:22:07.566+02
> -[ RECORD 3 ]--+-------------------------------------------------------
> [...]
> -[ RECORD 12 ]-+-------------------------------------------------------
> cal            | ethiopic
> now_str        | 17/mägabit/2013 après l’Incarnation 18:22:07.566 UTC+1
> now_parsed     | 2021-03-26 18:22:07.566+01
> plus_1m        | 18/miyazya/2013 après l’Incarnation 18:22:07.566 UTC+2
> plus_1m_parsed | 2021-04-26 18:22:07.566+02
> -[ RECORD 13 ]-+-------------------------------------------------------
> cal            | ethiopic-amete-alem
> now_str        | 17/mägabit/7513 ERA0 18:22:07.566 UTC+1
> now_parsed     | 2021-03-26 18:22:07.566+01
> plus_1m        | 18/miyazya/7513 ERA0 18:22:07.566 UTC+2
> plus_1m_parsed | 2021-04-26 18:22:07.566+02
> [...]
> I understand that adding months or years with some of the non-gregorian
> calendars should lead to different points in time than with the gregorian
> calendar.
>
> For instance with the ethiopic calendar, the query above displays today as
> 17/mägabit/2013 and 1 month from now as 18/miyazya/2013,
> while the correct result is probably 17/miyazya/2013 (?)

Seeing the results for Japanese locale, you might want to update your
ICU library, which could fix this potential inconsistency.

The results for the Japanese locale should be "0003 Reiwa" instead of
"0033 Heisei", as the era changed in 2019. ICU releases have since
implemented this and other corrections; this specific change was
implemented in the batched release of ICU versions on 2019-04-12.


With regards,

Matthias van de Meent



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

Предыдущее
От: Markus Wanner
Дата:
Сообщение: Re: [PATCH] Provide more information to filter_prepare
Следующее
От: Ajin Cherian
Дата:
Сообщение: Re: [PATCH] add concurrent_abort callback for output plugin