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()
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()