Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0mZu-0000AA-GY for pgsql-admin@arkaria.postgresql.org; Tue, 27 Mar 2018 11:15:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1f0mZt-0001bo-54 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Mar 2018 11:15:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0mZs-0001bf-L2 for pgsql-admin@lists.postgresql.org; Tue, 27 Mar 2018 11:15:44 +0000 Received: from mail-db5eur01on0136.outbound.protection.outlook.com ([104.47.2.136] helo=EUR01-DB5-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0mZn-0001kc-0j for pgsql-admin@lists.postgresql.org; Tue, 27 Mar 2018 11:15:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sibvisions.onmicrosoft.com; s=selector1-sibvisions-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=py6buontO4Ubp7fqt2g0B47BfZHMaU+0B8+4NNd3B5c=; b=aXn8qSKaC6Wl7orr7NYdr1Z3WTEiexVmc30nOwo1GvxHQBMgYYBphjt4f49estgE9ngL5RsjSnjpkU2mGhV5X8OkjspNe0mIYFuJ4/r++fkrZ7+s5a+Jz7TysKb+psrXjxchf3rXM/DwsfMgGtNMj6+l2QK5dmt1sw6Z4ybxKk8= Received: from VI1PR10MB1824.EURPRD10.PROD.OUTLOOK.COM (10.165.195.13) by VI1PR10MB0015.EURPRD10.PROD.OUTLOOK.COM (10.165.239.25) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P256) id 15.20.609.10; Tue, 27 Mar 2018 11:15:34 +0000 Received: from VI1PR10MB1824.EURPRD10.PROD.OUTLOOK.COM ([fe80::a901:ffdd:917b:94d4]) by VI1PR10MB1824.EURPRD10.PROD.OUTLOOK.COM ([fe80::a901:ffdd:917b:94d4%13]) with mapi id 15.20.0609.012; Tue, 27 Mar 2018 11:15:34 +0000 From: Robert Zenz To: "pgsql-admin@lists.postgresql.org" Subject: Re: Strange behavior of the timezone Thread-Topic: Strange behavior of the timezone Thread-Index: AQHTxa+tmnv1bz2b3EGuv0BueHeT2aPj1ZkAgAAVq4CAAAM0gA== Date: Tue, 27 Mar 2018 11:15:33 +0000 Message-ID: <5ABA27D5.2080504@sibvisions.com> References: <5ABA12F8.8040900@sibvisions.com> In-Reply-To: Accept-Language: de-AT, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=robert.zenz@sibvisions.com; x-originating-ip: [213.164.18.106] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;VI1PR10MB0015;7:3Yhyo3/HLcatMff2iKL6nqkDCGSjypOBpqegP2gb+FfRT61UDLsPjzJDrGnmgR0FUDxp0Mq6KBaTu5aOwpYFrpJrAvMVA8WLyxC2kx56hK63HF6qRIKtfF9ROml/UgV2fO3+so5Y/WnEmj0+x2nGa3AMUqTOXNGKumUwlrca8VJbl2QDuKPHSI1H+2X+VfqUhmZvvtkS+BplUp+1r2No/JIAhjOLBx7qzzOb/UfmKLp0BCju9Uto9UWjl4qyNKKf x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 28618421-51a4-4259-53f7-08d593d40f57 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(7021125)(5600026)(4604075)(3008032)(4534165)(7022125)(4603075)(7168020)(4627221)(201702281549075)(7048125)(7024125)(7027125)(7028125)(7023125)(2017052603328)(7153060)(7193020);SRVR:VI1PR10MB0015; x-ms-traffictypediagnostic: VI1PR10MB0015: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(158342451672863)(129827910884789); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(5005006)(8121501046)(93006095)(93001095)(3231221)(944501327)(52105095)(10201501046)(3002001)(6041310)(20161123560045)(20161123564045)(20161123558120)(2016111802025)(20161123562045)(6043046)(6072148)(201708071742011);SRVR:VI1PR10MB0015;BCL:0;PCL:0;RULEID:;SRVR:VI1PR10MB0015; x-forefront-prvs: 0624A2429E x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(376002)(346002)(396003)(39830400003)(39380400002)(366004)(199004)(189003)(377424004)(53546011)(3846002)(97736004)(59450400001)(5660300001)(105586002)(59896002)(6436002)(26005)(186003)(5640700003)(6506007)(3660700001)(2351001)(476003)(86362001)(102836004)(55236004)(6116002)(2900100001)(36756003)(6306002)(25786009)(14454004)(106356001)(6512007)(93886005)(76176011)(65816011)(5250100002)(6246003)(68736007)(66066001)(11346002)(80316001)(81156014)(99286004)(33656002)(446003)(2616005)(81166006)(53936002)(2501003)(3280700002)(87266011)(8936002)(229853002)(2906002)(6486002)(6916009)(7736002)(478600001)(8676002)(966005)(305945005)(316002)(486005)(486005);DIR:OUT;SFP:1102;SCL:1;SRVR:VI1PR10MB0015;H:VI1PR10MB1824.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: V/xYhMme/heqgJYKbP2rO9vPAgmy2IPiG8lS4NmI8eN4vIcQb3nC2gzSFOE1NTm+fdLZwOqbJ5ZCNlbj7nl3ah9cnN0CzJQLJoRbU3Whf5dMf7jk0voB0oJyH/xWQsEZ2sd14mdQo1j07Rs5fPtatZ/XZ7yUCQ6lz1k71UhfHQjqbJ4iISj/jZ4lGE0R46E/lDJygMleqr2/uQOdIO3cvTFLmA2gtL/57jFy3OXZcHmu34WS7lw+JIJPy8352gJ2VuBB9nXjEPve0Bbrrf98pJoXaQMnFkZM2UGnBr7MN6l3URFXHWb6Vrd+etGGo833axFHLFzlTRnYW4ZJvNQzTw== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: <2A3F0FF4B3DA494396A8AE3038F5D1CC@EURPRD10.PROD.OUTLOOK.COM> Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: 28618421-51a4-4259-53f7-08d593d40f57 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Mar 2018 11:15:34.1118 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: beb1b6aa-9998-4674-9056-cbc4fe8c7cad X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR10MB0015 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SGVyZSB5b3UgZ286DQoNCiAgICBodHRwczovL3d3dy50aW1lYW5kZGF0ZS5jb20vdGltZS9jaGFu Z2UvcnVzc2lhL21vc2Nvdz95ZWFyPTE5MTkNCg0KVGhhdCB3YXMgd2hhdCBJIHdhcyB0YWxraW5n IGFib3V0LCBvbiAxc3QgSnVseSwgMTkxOSB0aGUgY2xvY2tzIHdlcmUgdHVybmVkDQpiYWNrd2Fy ZHMgYnkgMzEgbWludXRlcyBhbmQgMTkgc2Vjb25kcy4gVGhhdCBhY2NvdW50cyBmb3IgdGhlIGRp ZmZlcmVuY2UgeW91IHNlZQ0KaGVyZSAocGx1cyBvciBtaW51cyBhIGxlYXBzZWNvbmQgb3IgdHdv LCBvciBzbywgZG9uJ3Qga25vdykuIFRoZSByZW1haW5pbmcgaG91cnMNCmRpZmZlcmVuY2UgYXJl IHNvbWV0aGluZyBhYm91dCBEU1QsIGJ1dCBJJ20gdG9vIGJ1c3kgdG8gbG9vayB0aGF0IHVwIGlu IGRldGFpbC4NCg0KV2hhdCBJIHdhbnRlZCB0byBzYXkgaXMgdGhhdCB0aW1lem9uZXMgZG8gbm90 IG9ubHkgdGFrZSAqY3VycmVudCogY2hhbmdlcyBpbnRvDQphY2NvdW50LCBidXQgYWxzbyAqcGFz dCogY2hhbmdlcy4gQWN0dWFsbHksIGFueSBrbm93biBjbG9jayBjaGFuZ2UgaXMgdGFrZW4gaW50 bw0KYWNjb3VudCwgdGhhdCBpbmNsdWRlcyBsZWFwIHNlY29uZHMgYW5kIGFueSBvdGhlciBhZGp1 c3RtZW50IG9mIHRoZSBjbG9jayAobWF5DQppdCBiZSBhZGRpbmcgb3IgcmVtb3ZpbmcgdGltZSku DQoNCg0KT24gMjcuMDMuMjAxOCAxMzowNCwgVmxhZCBBbGV4ZWVua292IHdyb3RlOg0KPiBPbiBz ZXJ2ZXIgLSBVVEMNCj4gTG9jYWwgLSBFdXJvcGUvTW9zY293DQo+IA0KPiBGb3IgZXhhbXBsZSwg ZnJvbSAxOTIwIGFsbCByaWdodDoNCj4gDQo+IElmIHJ1biBpbiBEYXRhR3JpcDoNCj4gDQo+IHNl bGVjdCAnMTkwMC0wMS0wMSAxNToxMToxMCc6OnRpbWVzdGFtcCB0MSwgJzE5MDAtMDEtMDEgMTU6 MTE6MTAnOjp0aW1lc3RhbXAgYXQNCj4gdGltZSB6b25lICdFdXJvcGUvTW9zY293JyBhcyB0Mg0K PiANCj4gMTkwMC0wMS0wMSAxNToxMToxMC4wMDAwMDAgICAgMTkwMC0wMS0wMSAxMjo0MDo1My4w MDAwMDANCj4gDQo+IHNlbGVjdCAnMTkyMC0wMS0wMSAxNToxMToxMCc6OnRpbWVzdGFtcCB0MSwg JzE5MjAtMDEtMDEgMTU6MTE6MTAnOjp0aW1lc3RhbXAgYXQNCj4gdGltZSB6b25lICdFdXJvcGUv TW9zY293JyBhcyB0Mg0KPiANCj4gMTkyMC0wMS0wMSAxNToxMToxMC4wMDAwMDAgICAgMTkyMC0w MS0wMSAxMjoxMToxMC4wMDAwMDANCj4gDQo+IHNlbGVjdCAnMTkwMC0wMS0wMSAxNToxMToxMCc6 OnRpbWVzdGFtcCB0MSwgJzE5MDAtMDEtMDEgMTU6MTE6MTAnOjp0aW1lc3RhbXAgYXQNCj4gdGlt ZSB6b25lICdVVEMtMycgYXMgdDINCj4gDQo+IDE5MDAtMDEtMDEgMTU6MTE6MTAuMDAwMDAwICAg IDE5MDAtMDEtMDEgMTI6MTE6MTAuMDAwMDAwDQo+IA0KPiBUaGFua3MNCj4gDQo+IE9uIDI3LjAz LjIwMTggMTI6NDYsIFJvYmVydCBaZW56IHdyb3RlOg0KPj4gVGhhdCBpcyBub3QgbmVjZXNzYXJp bHkgYSBzdHJhbmdlIGJlaGF2aW9yLCBhcyB0aGUgVGltZXpvbWUgbW9zdCBsaWtlbHkgaW5jbHVk ZXMNCj4+IGFsbCB0aGUgYWRqdXN0bWVudHMgdGhhdCB3ZXJlIG1hZGUgaW4gdGhlIHBlcmlvZCBv ZiB0aW1lIChsZWFwIHNlY29uZHMgYW5kIHRoZQ0KPj4gbGlrZSkuIEF0IGxlYXN0IGFzIGZhciBh cyBJIGtub3cuDQo+Pg0KPj4gSG93IGRvZXMgaXQgYmVoYXZlIGlmIHlvdSB0cnkgYSBtb3JlIGN1 cnJlbnQgZGF0ZSwgbGlrZSB0b2RheT8gV2hhdCBpcyB5b3VyDQo+PiBzeXN0ZW0vZGF0YWJhc2Ug dGltZXpvbmU/DQo+Pg0KPj4NCj4+IE9uIDI3LjAzLjIwMTggMTE6NDAsIFZsYWQgQWxleGVlbmtv diB3cm90ZToNCj4+PiBIaSENCj4+Pg0KPj4+IENhbiBhbnlvbmUgZXhwbGFpbiB0aGlzIGJlaGF2 aW9yPw0KPj4+DQo+Pj4gc2VsZWN0ICcxOTAwLTAxLTAxIDE1OjExOjEwJzo6dGltZXN0YW1wIHQx LCAnMTkwMC0wMS0wMSAxNToxMToxMCc6OnRpbWVzdGFtcCBhdA0KPj4+IHRpbWUgem9uZSAnRXVy b3BlL01vc2NvdycgYXMgdDINCj4+Pg0KPj4+ICAgdDEgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICB0Mg0KPj4+ID09PT09PT09PT09PT09PT09PT0gPT09PT09PT09PT09PT09 PT09PQ0KPj4+IDAxLjAxLjE5MDAgMTU6MTE6MTAgMDEuMDEuMTkwMCAxNTo0MDo1Mw0KPj4+DQo+ Pj4gU3RyYW5nZSBiZWhhdmlvciBvZiB0aGUgdGltZXpvbmUNCj4+Pg0KPj4+DQo+Pj4NCj4+Pg0K Pj4+IHNlbGVjdCB2ZXJzaW9uKCkNCj4+Pg0KPj4+IHZlcnNpb24NCj4+PiA9PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQ0KPj4+DQo+Pj4NCj4+PiBQb3N0Z3Jl U1FMIDkuNi41IG9uIHg4Nl82NC1wYy1saW51eC1nbnUsIGNvbXBpbGVkIGJ5IGdjYyAoR0NDKSA0 LjguNSAyMDE1MDYyMw0KPj4+IChSZWQgSGF0IDQuOC41LTExKSwgNjQtYml0DQo+Pj4NCj4+PiBU aGFua3MNCj4+Pg0KPiANCj4g