Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iam8d-0001Aa-0E for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Nov 2019 19:41:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iam8a-0007V9-JF for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Nov 2019 19:41:08 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1iam8a-0007V1-BC for pgsql-bugs@lists.postgresql.org; Fri, 29 Nov 2019 19:41:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iam8W-00076i-VL for pgsql-bugs@lists.postgresql.org; Fri, 29 Nov 2019 19:41:07 +0000 Content-Type: multipart/mixed; boundary="===============2663620954130343753==" MIME-Version: 1.0 Subject: BUG #16143: PGTYPEStimestamp_fmt_asc() returns the incorrect month when the format specifier %b is used. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: paul@intekon.com Reply-To: paul@intekon.com, pgsql-bugs@lists.postgresql.org Date: Fri, 29 Nov 2019 19:40:37 +0000 Message-ID: <16143-0d861eb8688d3fef@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2663620954130343753== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjE0MwpMb2dnZWQgYnk6ICAgICAgICAgIFBhdWwgU3BlbmNlcgpFbWFp bCBhZGRyZXNzOiAgICAgIHBhdWxAaW50ZWtvbi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMS41 Ck9wZXJhdGluZyBzeXN0ZW06ICAgUmVkaGF0IGFuZCBEZWJpYW4KRGVzY3JpcHRpb246ICAgICAg ICAKClBHVFlQRVN0aW1lc3RhbXBfZm10X2FzYygpIHJldHVybnMgdGhlIGluY29ycmVjdCBtb250 aCB3aGVuIHRoZSBmb3JtYXQKc3BlY2lmaWVyICViIGlzIHVzZWQuICBUaGUgcmV0dXJuZWQgbW9u dGggaXMgb25lIGdyZWF0ZXIgdGhlbiB0aGUgZXhwZWN0ZWQKbW9udGguICBJZiB0aGUgZXhwZWN0 ZWQgbW9udGggaXMg4oCcRGVj4oCdLCB0aGUgYXBwbGljYXRpb24gbWF5IGNyYXNoIHdpdGggYQpz ZWdtZW50IGZhdWx0LiAgVGhlIGZvcm1hdCBzcGVjaWZpZXIgJUIgaGFzIGEgc2ltaWxhciBpc3N1 ZS4NCg0KKiogSW52ZXN0aWdhdGlvbiBOb3Rlcw0KLSBUaGUgbW9udGggaXMgaW5jcmVhc2VkIGJ5 IG9uZSBhdCBsaW5lIDE0MyBpbiB0aW1lc3RhbXAydG0oKSBkZWZpbmVkIGluCnRpbWVzdGFtcC5j IOKAqGh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL2dpdHdlYi8/cD1wb3N0Z3Jlc3FsLmdpdDth PWJsb2I7Zj1zcmMvaW50ZXJmYWNlcy9lY3BnL3BndHlwZXNsaWIvdGltZXN0YW1wLmM7aD04MTBk ZDA2ZWU2OGI5ZTM5YmZiYjhkMWZiNGI1OGI4MjA1ZjI0MjQ2O2hiPUhFQUQNCi0gVGhlIG1vbnRo IG51bWJlciBpcyBjb252ZXJ0ZWQgdG8gdGhlIGFiYnJldmlhdGlvbiBhdCBsaW5lIDMzNyBpbgpk dHRvZm10YXNjX3JlcGxhY2UoKSBkZWZpbmVkIGluIHRpbWVzdGFtcC5jICDigKhodHRwczovL2dp dC5wb3N0Z3Jlc3FsLm9yZy9naXR3ZWIvP3A9cG9zdGdyZXNxbC5naXQ7YT1ibG9iO2Y9c3JjL2lu dGVyZmFjZXMvZWNwZy9wZ3R5cGVzbGliL3RpbWVzdGFtcC5jO2g9ODEwZGQwNmVlNjhiOWUzOWJm YmI4ZDFmYjRiNThiODIwNWYyNDI0NjtoYj1IRUFEDQotIE1vbnRoIGFiYnJldmlhdGlvbnMgYXJl IGRlZmluZWQgYXQgbGluZSA0OTkgaW4gZHRfY29tbW9uLmMg4oCoCmh0dHBzOi8vZ2l0LnBvc3Rn cmVzcWwub3JnL2dpdHdlYi8/cD1wb3N0Z3Jlc3FsLmdpdDthPWJsb2I7Zj1zcmMvaW50ZXJmYWNl cy9lY3BnL3BndHlwZXNsaWIvZHRfY29tbW9uLmM7aD1jMWEzYTNlMmNiN2UyZDRmMzc1YTNiMWEy ZTg1OGY3MzQ3YTg2N2VhO2hiPUhFQUQNCg0KKioqDQoqIFVzZSBDYXNlDQoqKioNCnBpQHJhc3Bi ZXJyeXBpNDp+L3Byb2plY3RzL3Bvc3RncmVzX21vbnRoX2RhdGUgJCAuL3BnX21vbnRoX2RhdGUN ClBvc3RncmVTUUwgdGltZXN0YW1wX2ZtdF9hc2MoKQ0KUEdUWVBFU3RpbWVzdGFtcF90b19hc2Mg cmV0dXJucyAxOTk5LTAxLTA4IDA0OjA2OjA2DQpGb3JtYXQgc3RyaW5nID0gJVktJW0tJWQgJUg6 JU06JVMsIEZvcm1hdGVkIERhdGUgPSAxOTk5LTAxLTA4IDA0OjA2OjA2DQpGb3JtYXQgc3RyaW5n ID0gJVktJWItJWQgJUg6JU06JVMsIEZvcm1hdGVkIERhdGUgPSAxOTk5LUZlYi0wOCAwNDowNjow Ng0KcGlAcmFzcGJlcnJ5cGk0On4vcHJvamVjdHMvcG9zdGdyZXNfbW9udGhfZGF0ZSAkDQoNCioq Kg0KKiBTb3VyY2UgY29kZSBmb3IgdGhlIHVzZSBjYXNlDQoqKioNCi8qDQogKiBwZ19tb250aF9k YXRlLmMNCiAqLw0KI2luY2x1ZGUgPHN0ZGlvLmg+DQojaW5jbHVkZSA8c3RyaW5nLmg+DQoNCiNp bmNsdWRlICJwZ3R5cGVzX3RpbWVzdGFtcC5oIg0KDQppbnQgbWFpbihpbnQgYXJnYywgY2hhciAq KmFyZ3YpDQp7DQogIGNoYXIgZm9ybWF0U3RyaW5nWzI1NV0gPSAiIjsNCiAgY2hhciBzdHJpbmdC dWZmZXJbMjU1XSA9ICIiOw0KICB0aW1lc3RhbXAgdGVzdFRpbWVzdGFtcDsNCiAgY2hhciAqIGVu ZFB0ciA9IE5VTEw7DQoNCiAgcHJpbnRmKCIlc1xuIiwiUG9zdGdyZVNRTCB0aW1lc3RhbXBfZm10 X2FzYygpIik7DQoNCiAgdGVzdFRpbWVzdGFtcCA9IFBHVFlQRVN0aW1lc3RhbXBfZnJvbV9hc2Mo IjE5OTktMDEtMDggMDQ6MDY6MDYiLAomZW5kUHRyKTsNCiAgcHJpbnRmKCJQR1RZUEVTdGltZXN0 YW1wX3RvX2FzYyByZXR1cm5zICVzXG4iLApQR1RZUEVTdGltZXN0YW1wX3RvX2FzYyh0ZXN0VGlt ZXN0YW1wKSk7DQogIA0KICBzdHJuY3B5KGZvcm1hdFN0cmluZywgIiVZLSVtLSVkICVIOiVNOiVT Iiwgc2l6ZW9mKGZvcm1hdFN0cmluZykpOw0KICBQR1RZUEVTdGltZXN0YW1wX2ZtdF9hc2MoJnRl c3RUaW1lc3RhbXAsIHN0cmluZ0J1ZmZlciwKc2l6ZW9mKHN0cmluZ0J1ZmZlciksZm9ybWF0U3Ry aW5nKTsNCiAgcHJpbnRmKCAiRm9ybWF0IHN0cmluZyA9ICVzLCBGb3JtYXRlZCBEYXRlID0gJXNc biIsIGZvcm1hdFN0cmluZyAsCnN0cmluZ0J1ZmZlcik7DQoNCiAgc3RybmNweShmb3JtYXRTdHJp bmcsICIlWS0lYi0lZCAlSDolTTolUyIsIHNpemVvZihmb3JtYXRTdHJpbmcpKTsNCiAgUEdUWVBF U3RpbWVzdGFtcF9mbXRfYXNjKCZ0ZXN0VGltZXN0YW1wLCBzdHJpbmdCdWZmZXIsCnNpemVvZihz dHJpbmdCdWZmZXIpLGZvcm1hdFN0cmluZyk7DQogIHByaW50ZiggIkZvcm1hdCBzdHJpbmcgPSAl cywgRm9ybWF0ZWQgRGF0ZSA9ICVzXG4iLCBmb3JtYXRTdHJpbmcgLApzdHJpbmdCdWZmZXIpOw0K ICByZXR1cm4gMDsNCn0gDQoNCg0KUGF1bCBTcGVuY2VyCgo= --===============2663620954130343753==--