Skip to content

Unknown time zone ID on date time with offset instead time zone #1268

@miroslav-mastny-regosys

Description

Firebird client doesn't handle select from column with type "datetime with offset", when value with time offset is inserted

FirebirdSql.Data.FirebirdClient v 10.3.4
FirebirdSql server v. 5.0.3

Testing table:
CREATE TABLE TEST
(
UTC_INSERT timestamp with time zone DEFAULT current_timestamp,
UTC_INSERT_OFFSET timestamp with time zone
);
insert into test(UTC_INSERT_OFFSET) VALUES ('2026-05-11 10:35 +01:00');

select * from test;
isql - return show value one value with time zone other with time offset correctly
UTC_INSERT UTC_INSERT_OFFSET
2026-05-11 08:28:18.3140 Europe/Prague 2026-05-11 10:35:00.0000 +01:00

FirebirdSql.Data.FirebirdClient return exception when DataReader try read result:

This exception was originally thrown at this call stack:
FirebirdSql.Data.Common.TypeHelper.CreateZonedDateTime(System.DateTime, ushort, short?)
FirebirdSql.Data.Client.Managed.XdrReaderWriter.ReadZonedDateTime(bool)
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.ReadRawValue(FirebirdSql.Data.Client.Managed.IXdrReader, FirebirdSql.Data.Common.DbField)
FirebirdSql.Data.Client.Managed.Version13.GdsStatement.ReadRow()
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()
FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()
FirebirdSql.Data.FirebirdClient.FbDataReader.Read()

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions