Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kugaL-0004MT-Kf for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Dec 2020 18:52:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kugaK-0004Ir-IP for pgsql-bugs@arkaria.postgresql.org; Wed, 30 Dec 2020 18:52:36 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kuf08-00066s-Jl for pgsql-bugs@lists.postgresql.org; Wed, 30 Dec 2020 17:11:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kuf03-0007sq-MU for pgsql-bugs@lists.postgresql.org; Wed, 30 Dec 2020 17:11:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=hgefYtPVHUZ+FFwPq/ec+rd3AoaX6OnyPIcGPhVxXUg=; b=cRQk7BZCFt2oEkUWgKIyoebnp1 C0wYpCXuz/b4NeMyi68uq1qtFhM+c92dUnCvP0V2l5vJiqKCdcZmud2TYPTFl4e+I03+memNPeLDv oRraBuEsDEPtiOGVwwza/mF73Mrc/jy0Q8zbUOK+3kkvi0/BwRz9lGzmYj+2QidTfPZh+Ix8jagt1 tFN/ON+X/m1WWLxJxmZBx+OsjbzrfdN3ljxiE0DW1nIDbSDcNjQg7uSz6ObRXAlkgJ91lU6k0uoRf OV8+vTNbc35caPGIJEc480EApZGIvkAuBus90wSLKl3swvEc7MvkUkwcKbQI2lo9PnSRt3FWDPYdt /GT4jGtg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kuf03-0002rB-7u for pgsql-bugs@lists.postgresql.org; Wed, 30 Dec 2020 17:11:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kuf02-0002Xg-48 for pgsql-bugs@lists.postgresql.org; Wed, 30 Dec 2020 17:11:02 +0000 Content-Type: multipart/mixed; boundary="===============3339294438861598935==" MIME-Version: 1.0 Subject: BUG #16797: EXTRACT(EPOCH FROM timestamp) is not using local timezone To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: djburd@gmail.com Reply-To: djburd@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 30 Dec 2020 17:10:17 +0000 Message-ID: <16797-f264b0b980b53b8b@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============3339294438861598935== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjc5NwpMb2dnZWQgYnk6ICAgICAgICAgIERhbmEgQnVyZApFbWFpbCBh ZGRyZXNzOiAgICAgIGRqYnVyZEBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi41Ck9w ZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIwLjA0LjEgTFRTCkRlc2NyaXB0aW9uOiAgICAgICAg CgpFWFRSQUNUKEVQT0NIIEZST00gdGltZXN0YW1wKSBzaG91bGQgYmUgdXNpbmcgdGhlIGxvY2Fs IHRpbWV6b25lIC0gd2hpY2ggY2FuCmJlIHNldCBpbiBzZXZlcmFsIHdheXMsIHNlZSBkb2N1bWVu dGF0aW9uICI4LjUuMy4gVGltZSBab25lcyIuICBIZXJlIEkgdXNlClNFVCBUSU1FIFpPTkUgdG8g c2V0IHRoZSBsb2NhbCB0aW1lem9uZSBmb3IgdGhlIGNsaWVudCBzZXNzaW9uLg0KDQotLSBFeHBl Y3RlZCByZXN1bHRzIChzZWVuIGZyb20gUG9zdGdyZVNRTCA5LjEuMTEpOg0KDQojIFNFVCBUSU1F IFpPTkUgJ0VTVDVFRFQnOyBzZWxlY3QgZXh0cmFjdChlcG9jaCBmcm9tICgnMDEvMDEvMTk3MAow MDowMDowMCc6OnRpbWVzdGFtcCkpOw0KU0VUDQogZGF0ZV9wYXJ0IA0KLS0tLS0tLS0tLS0NCiAg ICAgMTgwMDANCigxIHJvdykNCg0KLS0gUmVzdWx0cyBmcm9tIFBvc3RncmVTUUwgMTIuNToNCg0K IyBTRVQgVElNRSBaT05FICdFU1Q1RURUJzsgc2VsZWN0IGV4dHJhY3QoZXBvY2ggZnJvbSAoJzAx LzAxLzE5NzAKMDA6MDA6MDAnOjp0aW1lc3RhbXApKTsNClNFVA0KIGRhdGVfcGFydCANCi0tLS0t LS0tLS0tDQogICAgICAgICAwDQooMSByb3cpDQoNCi0tIEFkZGl0aW9uYWwgYW1iaWd1aXR5DQot LSBFeHBlY3RlZCByZXN1bHRzIChzZWVtIGZyb20gUG9zdGdyZVNRTCA5LjEuMTEpOg0KIyBTRVQg VElNRSBaT05FICdFU1Q1RURUJzsgc2VsZWN0IGV4dHJhY3QoZXBvY2ggZnJvbSAoJzAxLzAxLzE5 NzAKMDA6MDA6MDAnOjp0aW1lc3RhbXApKSwgZXh0cmFjdChlcG9jaCBmcm9tICgnMDEvMDEvMTk3 MAowMDowMDowMCc6OnRpbWVzdGFtcHR6KSkgd2hlcmUgJzAxLzAxLzE5NzAgMDA6MDA6MDAnOjp0 aW1lc3RhbXAgPQonMDEvMDEvMTk3MCAwMDowMDowMCc6OnRpbWVzdGFtcHR6Ow0KU0VUDQogZGF0 ZV9wYXJ0IHwgZGF0ZV9wYXJ0IA0KLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0NCiAgICAgMTgwMDAg fCAgICAgMTgwMDANCigxIHJvdykNCg0KLS0gQW1iaWd1b3VzIHJlc3VsdHMgZnJvbSBQb3N0Z3Jl U1FMIDEyLjU6DQojIFNFVCBUSU1FIFpPTkUgJ0VTVDVFRFQnOyBzZWxlY3QgZXh0cmFjdChlcG9j aCBmcm9tICgnMDEvMDEvMTk3MAowMDowMDowMCc6OnRpbWVzdGFtcCkpLCBleHRyYWN0KGVwb2No IGZyb20gKCcwMS8wMS8xOTcwCjAwOjAwOjAwJzo6dGltZXN0YW1wdHopKSB3aGVyZSAnMDEvMDEv MTk3MCAwMDowMDowMCc6OnRpbWVzdGFtcCA9CicwMS8wMS8xOTcwIDAwOjAwOjAwJzo6dGltZXN0 YW1wdHo7DQpTRVQNCiBkYXRlX3BhcnQgfCBkYXRlX3BhcnQgDQotLS0tLS0tLS0tLSstLS0tLS0t LS0tLQ0KICAgICAgICAgMCB8ICAgICAxODAwMA0KKDEgcm93KQ0KDQotLSBEb2N1bWVudGF0aW9u DQpodHRwczovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzLzEyL2RhdGF0eXBlLWRhdGV0aW1lLmh0 bWwNCjguNS4xLjMuIFRpbWUgU3RhbXBzDQoiQ29udmVyc2lvbnMgYmV0d2VlbiB0aW1lc3RhbXAg d2l0aG91dCB0aW1lIHpvbmUgYW5kIHRpbWVzdGFtcCB3aXRoIHRpbWUKem9uZSBub3JtYWxseSBh c3N1bWUgdGhhdCB0aGUgdGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25lIHZhbHVlIHNob3VsZCBi ZQp0YWtlbiBvciBnaXZlbiBhcyB0aW1lem9uZSBsb2NhbCB0aW1lLiINCg0KaHR0cHM6Ly93d3cu cG9zdGdyZXNxbC5vcmcvZG9jcy83LjQvcmVsZWFzZS03LTQuaHRtbA0KRS4yMDIuIFJlbGVhc2Ug Ny40DQpFLjIwMi4zLjcuIERhdGEgVHlwZSBhbmQgRnVuY3Rpb24gQ2hhbmdlcw0KIkNoYW5nZSBF WFRSQUNUKEVQT0NIIEZST00gdGltZXN0YW1wKSBzbyB0aW1lc3RhbXAgd2l0aG91dCB0aW1lIHpv bmUgaXMKYXNzdW1lZCB0byBiZSBpbiBsb2NhbCB0aW1lLCBub3QgR01UIChUb20pIg0KDQotLSBT ZXJ2ZXIgZGV0YWlscw0KLS0gT1MgdGltZXpvbmUgKHRob3VnaCB0aGlzIHNob3VsZCBub3QgbWF0 dGVyIHNpbmNlIGxvY2FsIHRpbWV6b25lIGlzIHNldCBpbgp0aGUgc2Vzc2lvbik6DQpPUyB0aW1l em9uZSBvZiBzZXJ2ZXIgd2l0aCBQb3N0Z3JlU1FMIDEyLjU6DQokIGRhdGUgKyIlWiAleiINClVU QyArMDAwMA0KDQotLSBQb3N0Z3JlU1FMIHZlcnNpb24NCiMgU0VMRUNUIHZlcnNpb24oKTsNCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIHZlcnNpb24gICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0Z3JlU1FMIDEyLjUg KFVidW50dSAxMi41LTB1YnVudHUwLjIwLjA0LjEpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsCmNv bXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDkuMy4wLTE3dWJ1bnR1MX4yMC4wNCkgOS4zLjAsIDY0LWJp dA0KKDEgcm93KQ0KDQotLSBQb3N0Z3JlU1FMIGluc3RhbGxlZCBmcm9tIHN0YW5kYXJkIFVidW50 dSBmb2NhbCByZXBvczoNCiQgbHNiX3JlbGVhc2UgLWENCk5vIExTQiBtb2R1bGVzIGFyZSBhdmFp bGFibGUuDQpEaXN0cmlidXRvciBJRDoJVWJ1bnR1DQpEZXNjcmlwdGlvbjoJVWJ1bnR1IDIwLjA0 LjEgTFRTDQpSZWxlYXNlOgkyMC4wNA0KQ29kZW5hbWU6CWZvY2FsDQoNCiQgYXB0IGxpc3QgLS1p bnN0YWxsZWQgfGdyZXAgLWkgcG9zdGdyZXMNCnBvc3RncmVzcWwtMTIvZm9jYWwtdXBkYXRlcyxm b2NhbC1zZWN1cml0eSxub3cgMTIuNS0wdWJ1bnR1MC4yMC4wNC4xIGFtZDY0CltpbnN0YWxsZWQs YXV0b21hdGljXQ0KcG9zdGdyZXNxbC1jbGllbnQtMTIvZm9jYWwtdXBkYXRlcyxmb2NhbC1zZWN1 cml0eSxub3cgMTIuNS0wdWJ1bnR1MC4yMC4wNC4xCmFtZDY0IFtpbnN0YWxsZWQsYXV0b21hdGlj XQ0KcG9zdGdyZXNxbC1jbGllbnQtY29tbW9uL2ZvY2FsLXVwZGF0ZXMsZm9jYWwtc2VjdXJpdHks bm93IDIxNHVidW50dTAuMSBhbGwKW2luc3RhbGxlZCxhdXRvbWF0aWNdDQpwb3N0Z3Jlc3FsLWNv bW1vbi9mb2NhbC11cGRhdGVzLGZvY2FsLXNlY3VyaXR5LG5vdyAyMTR1YnVudHUwLjEgYWxsCltp bnN0YWxsZWQsYXV0b21hdGljXQ0KcG9zdGdyZXNxbC9mb2NhbC11cGRhdGVzLGZvY2FsLXNlY3Vy aXR5LG5vdyAxMisyMTR1YnVudHUwLjEgYWxsIFtpbnN0YWxsZWRdCgo= --===============3339294438861598935==--