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. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
