Re: Calendar support in localization - Mailing list pgsql-hackers

From Matthias van de Meent
Subject Re: Calendar support in localization
Date
Msg-id CAEze2Wi+-WCYLkERKJgg+wB1BQ0WOXCw6u8dykS4UTB--3xBVQ@mail.gmail.com
Whole thread Raw
In response to Re: Calendar support in localization  ("Daniel Verite" <daniel@manitou-mail.org>)
Responses Re: Calendar support in localization  ("Daniel Verite" <daniel@manitou-mail.org>)
List 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 by date:

Previous
From: Markus Wanner
Date:
Subject: Re: [PATCH] Provide more information to filter_prepare
Next
From: Ajin Cherian
Date:
Subject: Re: [PATCH] add concurrent_abort callback for output plugin