On 2021-02-04 09:39, Norbert Saint Georges wrote:
yes, this is what I found but there is no definition RDB $ FIELD_TYPE = 30 or 31 in rdb $ types in FB4, what is it for?
The EXTENDED TIMESTAMP WITH TIME ZONE and EXTENDED TIME WITH TIME ZONE are protocol-only data-types, where it will always include the time zone offset, so client applications without named time zone support can determine the offset. See also SET BIND in the Firebird 4 RC-1 release notes.
I'm not sure if their absence from RDB$TYPES is an oversight or intentional (as they are protocol-only, and never surfaced in the metadata tables. It might be worthwhile to create a ticket in the tracker for this.
Mark Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel