Zoltan Ivanfi created HIVE-21351:
------------------------------------
Summary: TIMESTAMP WITH TIME ZONE
Key: HIVE-21351
URL: https://issues.apache.org/jira/browse/HIVE-21351
Project: Hive
Issue Type: Task
Reporter: Zoltan Ivanfi
As specified in the [design doc for TIMESTAMP
types|https://cwiki.apache.org/confluence/display/Hive/Different+TIMESTAMP+types],
the TIMESTAMP WITH TIME ZONE type shall behave like the
[OffsetDateTime|https://docs.oracle.com/javase/8/docs/api/java/time/OffsetDateTime.html]
class of Java, i.e., each individual value includes a time zone offset as
well. This definition leads to timestamps that not only identify specific time
instants unambiguously, but also allow retrieval of the originating time zone
offset.
For example, if storing 1969-07-20 16:17:39 in the Eastern Daylight Time to
this type, the stored data can be retrieved and displayed as "1969-07-20
16:17:39 (UTC -04:00)".
This behaviour is consistent with the SQL standard (revisions 2003 and higher).
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
