On 11-6-2019 16:35, Adriano dos Santos Fernandes wrote:
On 11/06/2019 11:22, liviuslivius wrote:
>from rdb$database - BOOM!
But why is that boom?
Why not show e.g.
11.06.2019 16:08 (GMT+01:00)?
This does require some conversion? This is stored during save process.
if user uses +01:00 (offset) it should work. If user uses a region, it's
a region, and any attempt to convert it to an offset automatically is
completely wrong.
And to convert a timestamp+region to display it, it requires time zone
tables, as the field stores the UTC time, not the displayable time.
I propose the following solution:
If ICU is present, use the current logic to derive the time in the
specified zone, but if ICU is absent, just display the UTC time
(+00:00). Don't throw errors for this.
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel