From: | Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> |
---|---|
To: | Daniel Verite <daniel(at)manitou-mail(dot)org> |
Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Surafel Temesgen <surafel3000(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Vik Fearing <vik(dot)fearing(at)enterprisedb(dot)com> |
Subject: | Re: Calendar support in localization |
Date: | 2021-03-29 10:57:55 |
Message-ID: | CAEze2Wi+-WCYLkERKJgg+wB1BQ0WOXCw6u8dykS4UTB--3xBVQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, 26 Mar 2021 at 18:51, Daniel Verite <daniel(at)manitou-mail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ajin Cherian | 2021-03-29 11:02:34 | Re: [PATCH] add concurrent_abort callback for output plugin |
Previous Message | Markus Wanner | 2021-03-29 10:52:01 | Re: [PATCH] Provide more information to filter_prepare |