Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7814CCC74 for ; Fri, 7 Jun 2013 16:48:26 +0000 (UTC) Received: (qmail 95573 invoked by uid 500); 7 Jun 2013 16:48:24 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 95454 invoked by uid 500); 7 Jun 2013 16:48:24 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 95438 invoked by uid 99); 7 Jun 2013 16:48:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Jun 2013 16:48:23 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mark.pundurs@nokia.com designates 147.243.128.24 as permitted sender) Received: from [147.243.128.24] (HELO mgw-da01.nokia.com) (147.243.128.24) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Jun 2013 16:48:17 +0000 Received: from vaebh104.NOE.Nokia.com (vaebh104.europe.nokia.com [10.160.244.30]) by mgw-da01.nokia.com (Sentrion-MTA-4.2.2/Sentrion-MTA-4.2.2) with ESMTP id r57GluNe024660 for ; Fri, 7 Jun 2013 19:47:56 +0300 Received: from vaebh106.NOE.Nokia.com ([10.160.244.32]) by vaebh104.NOE.Nokia.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 7 Jun 2013 19:47:55 +0300 Received: from smtp.mgd.nokia.com ([65.54.30.60]) by vaebh106.NOE.Nokia.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.3959); Fri, 7 Jun 2013 19:47:55 +0300 Received: from 008-AM1MPN1-031.mgdnok.nokia.com ([169.254.1.166]) by 008-AM1MMR1-005.mgdnok.nokia.com ([65.54.30.60]) with mapi id 14.02.0328.011; Fri, 7 Jun 2013 16:47:54 +0000 From: To: Subject: HQL *_utc_timestamp functions' timezone parameter? Thread-Topic: HQL *_utc_timestamp functions' timezone parameter? Thread-Index: Ac5jnilA+CXil6KRSUOlnzRBdvac8g== Date: Fri, 7 Jun 2013 16:49:12 +0000 Message-ID: <7C4081F8DADBE146A13A798A119006F11044C4@008-AM1MPN1-031.mgdnok.nokia.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.228.140.129] Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginalArrivalTime: 07 Jun 2013 16:47:55.0768 (UTC) FILETIME=[C2649F80:01CE639E] X-Nokia-AV: Clean X-Virus-Checked: Checked by ClamAV on apache.org The HQL *_utc_timestamp functions' timezone parameter appears to be documen= ted only as far as noting its existence. What are its allowed values? Does = it make any attempt to account for daylight savings time aka summer hours? = (If so, should that attempt be trusted?) Thanks in advance! Mark Pundurs Senior Data Analyst - Traffic HERE Chicago=20