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 1f0lBm-0003KD-Db for pgsql-admin@arkaria.postgresql.org; Tue, 27 Mar 2018 09:46: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 1f0lBl-0000d5-91 for pgsql-admin@arkaria.postgresql.org; Tue, 27 Mar 2018 09:46:45 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0lBk-0000cu-CT for pgsql-admin@lists.postgresql.org; Tue, 27 Mar 2018 09:46:45 +0000 Received: from mail-he1eur01on0131.outbound.protection.outlook.com ([104.47.0.131] helo=EUR01-HE1-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1f0lBf-0001Mf-TH for pgsql-admin@lists.postgresql.org; Tue, 27 Mar 2018 09:46:42 +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=/9kzlK99eHD5/vktYYFvQ53eCV+/AnIC2NuJHu7ZCvg=; b=gmcI2m1iIOKY7fhOMJWFlC5IjUOmWYM6IpxNqkAFmDSwiNkCtaQAHQTa/wgk0rJVlWvHGSVm3hzT+BLimUJX6aDNi8PmRiIZSqkYoxxiQclgNeBox/C9EBNfxyOjl/9YWiBuHkeF5h1IQSVws7W0AINI2h8RYEW+cOxf4Lpqfig= Received: from VI1PR10MB1824.EURPRD10.PROD.OUTLOOK.COM (10.165.195.13) by VI1PR10MB2048.EURPRD10.PROD.OUTLOOK.COM (52.134.28.153) 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 09:46:32 +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 09:46:32 +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+tmnv1bz2b3EGuv0BueHeT2aPj1ZkA Date: Tue, 27 Mar 2018 09:46:32 +0000 Message-ID: <5ABA12F8.8040900@sibvisions.com> References: 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;VI1PR10MB2048;7:/b21LWQD3qUiyUrKYEAY4prpnMGPQgbtmuAlhutlk+ESggHQxlQJwv/5sXy20RQ8I2thZ0kf8OjxPhVP7ABY/9n5IvP2X8mz16rrzi5DIYHU9NrL3XWRG4yUYLEPKP/R73Ms75xep5b41YrMBSoXN5xrTqOc/cdbzNkNUFTK7BJj2Ap0sOVoW3WbN6bqoqHp6/RTJyxqn1eYgu6ZGqHPo5XAmpS/IHvF5L7h7V7jjbvjImUPMwG63UooleHGzwz+ x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 4afb73b9-2f10-4b0b-2938-08d593c79f70 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:VI1PR10MB2048; x-ms-traffictypediagnostic: VI1PR10MB2048: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(8121501046)(5005006)(3002001)(10201501046)(93006095)(93001095)(3231221)(944501327)(52105095)(6041310)(20161123562045)(2016111802025)(20161123560045)(20161123564045)(20161123558120)(6043046)(6072148)(201708071742011);SRVR:VI1PR10MB2048;BCL:0;PCL:0;RULEID:;SRVR:VI1PR10MB2048; x-forefront-prvs: 0624A2429E x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(396003)(376002)(366004)(39830400003)(346002)(39380400002)(189003)(377424004)(199004)(2616005)(6116002)(106356001)(8936002)(14454004)(2501003)(81166006)(8676002)(53546011)(81156014)(5660300001)(3846002)(2900100001)(478600001)(25786009)(105586002)(316002)(6506007)(102836004)(476003)(59896002)(86362001)(2351001)(5250100002)(186003)(26005)(11346002)(55236004)(66066001)(446003)(7736002)(87266011)(68736007)(76176011)(65816011)(99286004)(33656002)(305945005)(3660700001)(6436002)(6486002)(6916009)(229853002)(36756003)(80316001)(6246003)(5640700003)(6512007)(53936002)(97736004)(3280700002)(2906002)(486005)(486005);DIR:OUT;SFP:1102;SCL:1;SRVR:VI1PR10MB2048;H:VI1PR10MB1824.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: +1y/KZGflKYGMgVnk1MwHHj3AK6Qk8srSdG8x4waT9n0xmJKSWMSJ6V+23gwJc747nGEJdFnqJkm3f6RNoqvxIctAix/B8p3ndQPDEFwIuF8MATbg1F+xBAJ1nW27O7TI+FaqBDDjwOgl+xiTeOL6bIHqP+lldo1nzljroGlYG/64ZG/2PYfSYXFhzmNSh48gGUwnQr43/L3s1yRJvO9MRAz+/evCE3SuCyNcVOOByFpbWNnjBQ6xyJ5nVGLMeudiVaHAPBVJ9lrxo/a145AIeiBimA39X1AMomqCb1XiukLJiDJXTk9EoKURgvmxup82HfwF4LR1zcnErwrjPWmhg== spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: 4afb73b9-2f10-4b0b-2938-08d593c79f70 X-MS-Exchange-CrossTenant-originalarrivaltime: 27 Mar 2018 09:46:32.4402 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: beb1b6aa-9998-4674-9056-cbc4fe8c7cad X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR10MB2048 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk VGhhdCBpcyBub3QgbmVjZXNzYXJpbHkgYSBzdHJhbmdlIGJlaGF2aW9yLCBhcyB0aGUgVGltZXpv bWUgbW9zdCBsaWtlbHkgaW5jbHVkZXMNCmFsbCB0aGUgYWRqdXN0bWVudHMgdGhhdCB3ZXJlIG1h ZGUgaW4gdGhlIHBlcmlvZCBvZiB0aW1lIChsZWFwIHNlY29uZHMgYW5kIHRoZQ0KbGlrZSkuIEF0 IGxlYXN0IGFzIGZhciBhcyBJIGtub3cuDQoNCkhvdyBkb2VzIGl0IGJlaGF2ZSBpZiB5b3UgdHJ5 IGEgbW9yZSBjdXJyZW50IGRhdGUsIGxpa2UgdG9kYXk/IFdoYXQgaXMgeW91cg0Kc3lzdGVtL2Rh dGFiYXNlIHRpbWV6b25lPw0KDQoNCk9uIDI3LjAzLjIwMTggMTE6NDAsIFZsYWQgQWxleGVlbmtv diB3cm90ZToNCj4gSGkhDQo+IA0KPiBDYW4gYW55b25lIGV4cGxhaW4gdGhpcyBiZWhhdmlvcj8N Cj4gDQo+IHNlbGVjdCAnMTkwMC0wMS0wMSAxNToxMToxMCc6OnRpbWVzdGFtcCB0MSwgJzE5MDAt MDEtMDEgMTU6MTE6MTAnOjp0aW1lc3RhbXAgYXQNCj4gdGltZSB6b25lICdFdXJvcGUvTW9zY293 JyBhcyB0Mg0KPiANCj4gIHQxICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg dDINCj4gPT09PT09PT09PT09PT09PT09PSA9PT09PT09PT09PT09PT09PT09DQo+IDAxLjAxLjE5 MDAgMTU6MTE6MTAgMDEuMDEuMTkwMCAxNTo0MDo1Mw0KPiANCj4gU3RyYW5nZSBiZWhhdmlvciBv ZiB0aGUgdGltZXpvbmUNCj4gDQo+IA0KPiANCj4gDQo+IHNlbGVjdCB2ZXJzaW9uKCkNCj4gDQo+ IHZlcnNpb24NCj4gPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09 PT0NCj4gDQo+IFBvc3RncmVTUUwgOS42LjUgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGls ZWQgYnkgZ2NjIChHQ0MpIDQuOC41IDIwMTUwNjIzDQo+IChSZWQgSGF0IDQuOC41LTExKSwgNjQt Yml0DQo+IA0KPiBUaGFua3MNCj4gDQo+IA==