[ORC-340] ConvertTreeReaderFactory does not take into account timezone information

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Not A Problem
• Component/s: evolution
• Assignee: Unassigned
• Reporter: Jesús Camacho Rodríguez
• Created: 13/Apr/18 15:35
• Updated: 27/Feb/24 22:23
• Resolved: 19/Jul/19 22:55

Description

When converting timestamp/date to string group, toString is called on java.sql.Date and java.sql.Timestamp, which pick up the default time zone to represent the date/time as a String. This can lead to the wrong String representation. See ConvertTreeReaderFactory.StringGroupFromTimestampTreeReader or ConvertTreeReaderFactory.StringGroupFromDateTreeReader.

StringGroupFromTimestampTreeReader should apply shifting, similar to TreeReaderFactory.TimestampTreeReader.
StringGroupFromDateTreeReader should use a date formatter in UTC.