TIMESTAMP WITH TIME ZONE

As specified in the design doc for TIMESTAMP types, the TIMESTAMP WITH TIME ZONE type shall behave like the OffsetDateTime 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).