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 1jK2Fh-0006nt-LR for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Apr 2020 15:59:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jK2Fg-0008Ob-Hq for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Apr 2020 15:59:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jK2CN-0003ol-1U for pgsql-bugs@lists.postgresql.org; Thu, 02 Apr 2020 15:56:07 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jK2CJ-0004KU-8u for pgsql-bugs@lists.postgresql.org; Thu, 02 Apr 2020 15:56:06 +0000 Content-Type: multipart/mixed; boundary="===============6545166507547899362==" MIME-Version: 1.0 Subject: BUG #16338: casting interval '24h' to time returns '00:00:00' instead of '24:00:00' To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: iomihai@hotmail.com Reply-To: iomihai@hotmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 02 Apr 2020 15:55:18 +0000 Message-ID: <16338-b198c8cc2395ba5f@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6545166507547899362== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjMzOApMb2dnZWQgYnk6ICAgICAgICAgIElvIE1paGFpCkVtYWlsIGFk ZHJlc3M6ICAgICAgaW9taWhhaUBob3RtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjIK T3BlcmF0aW5nIHN5c3RlbTogICBBcmNoIExpbnV4LCBVYm50dQpEZXNjcmlwdGlvbjogICAgICAg IAoKV2hpbGUgY2FzdGluZyBpbnRlcnZhbHMgdG8gdGltZSBJIG5vdGljZWQgaW50ZXJ2YWwgJzI0 aCcgY2FzdHMgdG8gJzAwOjAwOjAwJwp0aW1lIHJhdGhlciB0aGFuICcyNDowMDowMCcNCkNhc3Rp bmcgZmlyc3QgdG8gdGV4dCBvciB2YXJjaGFyIHRoZW4gdG8gdGltZSB3b3JrcyBhcyBleHBlY3Rl ZA0Kc2VsZWN0IChpbnRlcnZhbCAnMjRoJyk6OnRpbWU7ID0+ICcwMDowMDowMCcNCnNlbGVjdCAo aW50ZXJ2YWwgJzI0aCcpOjp0ZXh0Ojp0aW1lID0+ICcyNDowMDowMCc7DQpJIGV4cGVyaWVuY2Vk IHRoaXMgaW4gUG9zdGdyZVNRTCAgOSAtMTIgLg0KSXMgdGhpcyBhIGJ1ZyBvciBpcyB0aGlzIGhv dyBpdCBpcyBzdXBwb3NlZCB0byB3b3JrPw0KDQpUaGFuayB5b3UsDQpNaWhhaQoK --===============6545166507547899362==--