Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKeoH-00BUEs-O1 for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Jun 2024 14:00:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sKeoF-001VL6-TF for pgsql-bugs@arkaria.postgresql.org; Fri, 21 Jun 2024 14:00:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKJnd-009vOT-6X for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 15:34:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKJnb-002fcZ-NI for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 15:34:09 +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=R+JIO/+Lry1wbvGcbx2aYox9CnK6cQ/ZFlWGbZ1Qwi0=; b=rzl4WxB9XLhg8M+qV8APUMu8k/ FLN/xKVP+ihlnamCNNz58I4dkCILC7bx5oL6jFou4ntxVt+azNKgycaWdkCga9Iooffe/riUQw3cd OwKMjFn4SDlnmZNnYAF/qEPgJsNrfPtUkoEFiI3kH8/8T61GyYg32k9pxjgZSm+Mi+1FAS/Tfo5VP 0Xj7xn5SiDYyeNcLSu+DGK7OjEJthJwOkH4KV29bASLdrid985XrG2sT56XFfqc/bkpWqiguaBudT TgCqJGGC9Lii95Kz5Vtcwgjn+6j7dQmQ1MuDRW8qTHrer66Hz+Z4o3Mx2Q3AxKRX3aqQFb9RCa/qU 3+DGjTJg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sKJnZ-007CP2-39 for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 15:34:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sKJnW-000MZU-GD for pgsql-bugs@lists.postgresql.org; Thu, 20 Jun 2024 15:34:03 +0000 Content-Type: multipart/mixed; boundary="===============7085593425001383436==" MIME-Version: 1.0 Subject: BUG #18518: ::timestamp add minutes and seconds to the converted values To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nicola.oricchio@vertigis.com Reply-To: nicola.oricchio@vertigis.com, pgsql-bugs@lists.postgresql.org Date: Thu, 20 Jun 2024 15:33:29 +0000 Message-ID: <18518-e16f6cc69c9ce413@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7085593425001383436== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODUxOApMb2dnZWQgYnk6ICAgICAgICAgIE5pY29sYSBPcmljY2hpbwpF bWFpbCBhZGRyZXNzOiAgICAgIG5pY29sYS5vcmljY2hpb0B2ZXJ0aWdpcy5jb20KUG9zdGdyZVNR TCB2ZXJzaW9uOiAxMi4xOApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dQpEZXNjcmlwdGlvbjog ICAgICAgIAoKcmVwcm86DQpjcmVhdGUgdGFibGUgYWFhIChkYXQgdGltZXN0YW1wIHdpdGhvdXQg dGltZSB6b25lKTsNCmluc2VydCBpbnRvIGFhYSB2YWx1ZXMgKCcxODkyLTEyLTMxIDIzOjAwOjAw Jyk7DQppbnNlcnQgaW50byBhYWEgdmFsdWVzICgnMTg5My0xMi0zMSAyMzowMDowMCcpOw0KaW5z ZXJ0IGludG8gYWFhIHZhbHVlcyAoJzE5OTItMTItMzEgMTM6MzM6MTInKTsNCnNlbGVjdCBkYXQs IChkYXQgYXQgdGltZSB6b25lICd1dGMnKTo6dGltZXN0YW1wIHdpdGhvdXQgdGltZSB6b25lIGZy b20gYWFhCm9yZGVyIGJ5IDE7DQoNCm91dHB1dDoNCiAgICAgICAgIGRhdCAgICAgICAgIHwgICAg ICB0aW1lem9uZQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K IDE4OTItMTItMzEgMjM6MDA6MDAgfCAxODkzLTEyLTMxIDIzOjUzOjI4IDwtLSBpdCBzaG91bGQg YmUgMTg5My0wMS0wMQowMDowMDowMA0KIDE4OTMtMTItMzEgMjM6MDA6MDAgfCAxODk0LTAxLTAx IDAwOjAwOjAwDQogMTk5Mi0xMi0zMSAxMzozMzoxMiB8IDE5OTItMTItMzEgMTQ6MzM6MTINCg0K aXQgd29ya3MgY29ycmVjdGx5IHdpdGggMTIuMg0KICAgICAgICAgZGF0ICAgICAgICAgfCAgICAg IHRpbWV6b25lDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQog MTg5Mi0xMi0zMSAyMzowMDowMCB8IDE4OTMtMDEtMDEgMDA6MDA6MDANCiAxODkzLTEyLTMxIDIz OjAwOjAwIHwgMTg5NC0wMS0wMSAwMDowMDowMA0KIDE5OTItMTItMzEgMTM6MzM6MTIgfCAxOTky LTEyLTMxIDE0OjMzOjEyDQoNCnRpbWUgem9uZSBpcyBDRVQKCg== --===============7085593425001383436==--