From dev-return-53869-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Thu Sep 6 20:26:55 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 51F5A180668 for ; Thu, 6 Sep 2018 20:26:55 +0200 (CEST) Received: (qmail 71108 invoked by uid 500); 6 Sep 2018 18:26:54 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 71097 invoked by uid 99); 6 Sep 2018 18:26:54 -0000 Received: from mail-relay.apache.org (HELO mailrelay1-lw-us.apache.org) (207.244.88.152) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 06 Sep 2018 18:26:54 +0000 Received: from mail-it0-f43.google.com (mail-it0-f43.google.com [209.85.214.43]) by mailrelay1-lw-us.apache.org (ASF Mail Server at mailrelay1-lw-us.apache.org) with ESMTPSA id 85F57D32 for ; Thu, 6 Sep 2018 18:26:53 +0000 (UTC) Received: by mail-it0-f43.google.com with SMTP id h3-v6so16687305ita.2 for ; Thu, 06 Sep 2018 11:26:53 -0700 (PDT) X-Gm-Message-State: APzg51Cjdg9pgeliQTTi8IrxQ+ux2jIO+gDIIpwR+0PzguQUdx/zbKO5 JfeE3HWroMX1WVhdu4Y2OJl/TyNCgbCK1FFhRo0= X-Google-Smtp-Source: ANB0VdbbIrXbaWvn+JNn6WwPvrSwGJhop4eVD5W1tG6JUbG0HLWKLm6SWyd/DBWJi8T9cCdqDgVNrVYHYfYeDytKzG4= X-Received: by 2002:a6b:5903:: with SMTP id n3-v6mr3167333iob.176.1536258413006; Thu, 06 Sep 2018 11:26:53 -0700 (PDT) MIME-Version: 1.0 From: Pedro Boado Date: Thu, 6 Sep 2018 19:26:41 +0100 X-Gmail-Original-Message-ID: Message-ID: Subject: Question - Internal representation for Dates and Times To: dev@phoenix.apache.org Content-Type: multipart/alternative; boundary="000000000000fd95340575380880" --000000000000fd95340575380880 Content-Type: text/plain; charset="UTF-8" Hi, I was wondering about the historical reason for storing DATE and TIME types as milliseconds instead of days since unix epoch and seconds since midnight as normally databases do. Anyone remembers it? Our users are sometimes confused by sqlline representation for these data types. Cheers! Pedro. --000000000000fd95340575380880--