drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Julian Hyde <jh...@apache.org>
Subject Re: Drill date & time types encoding
Date Thu, 16 Mar 2017 23:41:07 GMT

> On Mar 16, 2017, at 4:25 PM, Jinfeng Ni <jni@apache.org> wrote:
> 
> Time/Timestamp without t/z should be interpreted as local time.


No.

If I am in pacific time and I have a TIMESTAMP value “1970-01-01 12:00:00” and I send
it to you in central european time you receive a TIMESTAMP value “1970-01-01 12:00:00”.

Its time zone is not my local time zone, or your local time zone, or UTC. It has no time zone.

Julian


Mime
View raw message