[AVRO-4080] C# local-timestamp-* conversions are affected by local time zone

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.11.1, 1.12.0
• Component/s: csharp, logical types

Language

C#

• Assignee: Unassigned
• Reporter: Kalle Niemitalo
• Created: 16/Oct/24 14:07
• Updated: 16/Oct/24 14:17

Description

In the C# implementation of logical types "local-timestamp-millis" and "local-timestamp-micros", the conversion between DateTime and Int64 depends on the local time zone of the process: ConvertToBaseValue calls DateTime.ToUniversalTime(), and ConvertToLogicalValue calls DateTime.ToLocalTime().  These time zone conversions should not be done. Instead, ConvertToBaseValue should discard DateTime.Kind, and ConvertToLogicalValue should set DateTimeKind.Unspecified.

According to the Avro 1.12.0 specification:

The time-millis logical type represents a time of day, with no reference to a particular calendar, time zone or date, with a precision of one millisecond.

As there is no reference to a time zone, the value must not be assumed to be in the local time zone of the process. The current C# implementation is not consistent with the Java implementation, either.

Issue Links

• Discovered while testing: AVRO-3078 C#: Logical type 'local-timestamp-millis'