Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43913=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YsK4S-0005be-4v
 for pgsql-admin@arkaria.postgresql.org; Tue, 12 May 2015 23:58:44 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43913=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YsK4R-0003WC-4a
 for pgsql-admin@arkaria.postgresql.org; Tue, 12 May 2015 23:58:43 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1YsK4Q-0003W6-Ay
 for pgsql-admin@postgresql.org; Tue, 12 May 2015 23:58:42 +0000
Received: from mailout.easymail.ca ([64.68.201.169])
 by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <scott_ribe@elevated-dev.com>)
 id 1YsK4N-0001WC-C7
 for pgsql-admin@postgresql.org; Tue, 12 May 2015 23:58:41 +0000
Received: from localhost (localhost [127.0.0.1])
 by mailout.easymail.ca (Postfix) with ESMTP id E4BC0E12A;
 Tue, 12 May 2015 19:58:37 -0400 (EDT)
X-Virus-Scanned: Debian amavisd-new at mailout.easymail.ca
X-Spam-Flag: NO
X-Spam-Score: -3.9
X-Spam-Level: 
X-Spam-Status: No, score=-3.9 required=5 tests=[ALL_TRUSTED=-1.8, AWL=-0.193,
 BAYES_00=-2.599, DNS_FROM_AHBL_RHSBL=0.692]
Received: from mailout.easymail.ca ([127.0.0.1])
 by localhost (easymail-mailout.easydns.vpn [127.0.0.1]) (amavisd-new,
 port 10024)
 with ESMTP id PO2Vi0lCwK30; Tue, 12 May 2015 19:58:37 -0400 (EDT)
Received: from [192.168.2.16] (unknown [8.39.228.5])
 (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
 (No client certificate requested)
 by mailout.easymail.ca (Postfix) with ESMTPSA id 5C736E122;
 Tue, 12 May 2015 19:58:37 -0400 (EDT)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 8.2 \(2098\))
Subject: Re: Timestamp Shifts when calling to_timestamp(extract (epoch from
 timestamp))
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: 
 <CACT-NGKK1vQxb+UDwj_Ji6co+COf-6P6nm7YAME+e4L4xvbJuA@mail.gmail.com>
Date: Tue, 12 May 2015 17:58:35 -0600
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <18E25F6F-7209-43A3-BEAB-8A85D2A47461@elevated-dev.com>
References: 
 <CACT-NGKQRtBGKOGUMT_goxyKu=yym8ET1Q5my-yjfuWW++uXbA@mail.gmail.com>
 <4FD9A31F-C7E3-4A27-B431-5B284BD3EF28@elevated-dev.com>
 <CACT-NGL+0jSEaz4MQZLkdv7FmdcTPuvhNKxqzpVw3+S4yXfFjg@mail.gmail.com>
 <4272FB86-B759-42FD-8DAF-1B4C5D1E218A@elevated-dev.com>
 <CACT-NGKK1vQxb+UDwj_Ji6co+COf-6P6nm7YAME+e4L4xvbJuA@mail.gmail.com>
To: Robert Burgholzer <rburghol@vt.edu>
X-Mailer: Apple Mail (2.2098)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On May 12, 2015, at 5:49 PM, Robert Burgholzer <rburghol@vt.edu> wrote:
>=20
> to_timestamp translates into the local TZ Always.

No, it translates to UTC, but timestamps by default display in your local t=
imezone. Look at your example, the result of to_timestamp is midnight UTC a=
s expected, which in your time zone is 19:00.

--=20
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin