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.96) (envelope-from ) id 1vKifF-0061ry-03 for pgsql-general@arkaria.postgresql.org; Sun, 16 Nov 2025 19:43:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vKifA-00BA7v-26 for pgsql-general@arkaria.postgresql.org; Sun, 16 Nov 2025 19:43:52 +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.96) (envelope-from ) id 1vKifA-00BA7m-0m for pgsql-general@lists.postgresql.org; Sun, 16 Nov 2025 19:43:52 +0000 Received: from mout02.posteo.de ([185.67.36.66]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vKif7-00856E-1h for pgsql-general@postgresql.org; Sun, 16 Nov 2025 19:43:51 +0000 Received: from submission (posteo.de [185.67.36.169]) by mout02.posteo.de (Postfix) with ESMTPS id C7A76240101 for ; Sun, 16 Nov 2025 20:43:47 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=posteo.net; s=2017; t=1763322227; bh=XJS7YAjX+vt8PGBbWui+neYfYplTpC+kTq9UfJGeGIA=; h=MIME-Version:Date:From:To:Subject:Message-ID:Content-Type: Content-Transfer-Encoding:From; b=bAdqEsifam7rxcPQB9eiymz4pex06ZK0QoQNkuTqtxFOsqTWndHJq2VUiigrvLaIp dW0zsjtnsCRBLaT7dAny5dCb2VKzihRNk8wdT11/fsSkPs8fnSAqgr7uSbCBNd8Ngq hCnMoU2NqB+/k9s/222qyTlVhfkzaZQp5MmZg+/QwN4gZ1kN7NvDSqTjgp5jDP59U4 No74/O2Uj4lPDWDbMEz7njdSkhByLHAz6xPjDIlCfmB6ecC8mN2fHr4UbUawbDjaVR 8JP1k5cFX+vig+EiELh/o78YSH3ZiF1fwIyiOnUbwgjMf+m3bSb9AjUkqMXTaqqQbn hfjqbsKmOgnVw== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4d8hBq384Gz6tvs for ; Sun, 16 Nov 2025 20:43:47 +0100 (CET) MIME-Version: 1.0 Date: Sun, 16 Nov 2025 19:43:47 +0000 From: pgmis@posteo.net To: pgsql-general@postgresql.org Subject: RFC 9557 / IXDTF Message-ID: <145c7185c29456e42a9325fe1df63222@posteo.net> Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, does postgres consider some sort of implementation of rfc9557 IXDTF? This is new time internet time format which extends timestamps with timezone info together with the offset - https://datatracker.ietf.org/doc/html/rfc9557 - https://en.wikipedia.org/wiki/RFC_9557#Usage If not, is there some suggestion on how to best store information like this? Thanks, Miroslav