Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 39D6F200C3A for ; Fri, 17 Mar 2017 00:41:16 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 38789160B8B; Thu, 16 Mar 2017 23:41:16 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 822DB160B78 for ; Fri, 17 Mar 2017 00:41:15 +0100 (CET) Received: (qmail 71689 invoked by uid 500); 16 Mar 2017 23:41:14 -0000 Mailing-List: contact dev-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list dev@drill.apache.org Received: (qmail 71674 invoked by uid 99); 16 Mar 2017 23:41:14 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Mar 2017 23:41:14 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 03F32C1A91 for ; Thu, 16 Mar 2017 23:41:14 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.096 X-Spam-Level: X-Spam-Status: No, score=-0.096 tagged_above=-999 required=6.31 tests=[HEADER_FROM_DIFFERENT_DOMAINS=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.096, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id HAp5bsP2oFMQ for ; Thu, 16 Mar 2017 23:41:13 +0000 (UTC) Received: from mail-pf0-f172.google.com (mail-pf0-f172.google.com [209.85.192.172]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 23F745F238 for ; Thu, 16 Mar 2017 23:41:13 +0000 (UTC) Received: by mail-pf0-f172.google.com with SMTP id x63so25840504pfx.2 for ; Thu, 16 Mar 2017 16:41:13 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:date:references:to:in-reply-to:message-id; bh=w07+mLx7S66SfjbN4fQhtxQr5Mk+WKTLk+EKrcJszx4=; b=FSdsKqic3RMnC36VitFNaTkQjjiOzoHqiX+H6jbDuFvGwiDa4kk//xCLDUNFJe8yD/ h1oW3i+5pRm4aL23KermW0yMMMmYQ77aMfYWiCAevrO4Sf2go/U//2wp7JX2sFT272ps rSKWS+wWCHiszfXWT54ViP749MWkRCrK9a3DyFj+kefP8PnoquEtbqLRZtZW5YuTUhw4 Yro+ZgAcIOk5oHABmBBgbR9sWlnMCX28baTARQrPQI0Fo/KuhgdFZ59ci0p7NmOPQDhC cWiPAgTbhXwcCqBETX83x/pZoL5RaXERv0IhdWdmp/khLndH+9OYQwKnnN3dYOxcMpuI J/sQ== X-Gm-Message-State: AFeK/H18yveHjvRZDV0lX5LQln+IYTOe9vK8AIIIwBAHPllgWaVAh+b1qMZTNw2vOxALgQ== X-Received: by 10.84.231.141 with SMTP id g13mr10309676plk.157.1489707672156; Thu, 16 Mar 2017 16:41:12 -0700 (PDT) Received: from [192.168.2.109] (c-50-184-110-23.hsd1.ca.comcast.net. [50.184.110.23]) by smtp.gmail.com with ESMTPSA id d189sm12689496pga.17.2017.03.16.16.41.11 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 16 Mar 2017 16:41:11 -0700 (PDT) From: Julian Hyde Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 10.2 \(3259\)) Subject: Re: Drill date & time types encoding Date: Thu, 16 Mar 2017 16:41:07 -0700 References: <0CAE7E09-8C48-4442-8F64-E5C04CA4E309@mapr.com> <0E296A5B-C645-4BD5-80E9-0168B60D26C0@apache.org> To: "dev@drill.apache.org" In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.3259) archived-at: Thu, 16 Mar 2017 23:41:16 -0000 > On Mar 16, 2017, at 4:25 PM, Jinfeng Ni wrote: >=20 > Time/Timestamp without t/z should be interpreted as local time. No. If I am in pacific time and I have a TIMESTAMP value =E2=80=9C1970-01-01 = 12:00:00=E2=80=9D and I send it to you in central european time you = receive a TIMESTAMP value =E2=80=9C1970-01-01 12:00:00=E2=80=9D. Its time zone is not my local time zone, or your local time zone, or = UTC. It has no time zone. Julian