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 1pFzfU-0000js-RU for pgsql-general@arkaria.postgresql.org; Thu, 12 Jan 2023 15:39:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFzfT-0007z9-NN for pgsql-general@arkaria.postgresql.org; Thu, 12 Jan 2023 15:39:03 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFzfR-0007xz-Vn for pgsql-general@lists.postgresql.org; Thu, 12 Jan 2023 15:39:03 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFzfP-00029j-7n for pgsql-general@lists.postgresql.org; Thu, 12 Jan 2023 15:39:01 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id D69745C0126; Thu, 12 Jan 2023 10:38:55 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 12 Jan 2023 10:38:55 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to; s=fm2; t=1673537935; x= 1673624335; bh=0fiGbaAtyZKHVVBpzzV+Tpqper1kzIwxK+JYysg3zK0=; b=V QHMORzMB+htnEeaiP878NDjRY7C8ZramPVxgVpIZtvJQ7MMyhECp9KLjfKYEarwd JBip9xB3CrQHjQIhW7B0/afHXSFbUjMVPV8QLU+TR3skcrAt/H+s2gfySawumruL nknKHJVHJm5Dij3oioBOiH4em1al7LIxROtyrt0YnP+2f8+3PTfm9Jrl9lNta933 ijh9r5p9UmGhOHFccbDoSlSwS6c+qbaAAITr1Y5ZOnBsXjB1/OTJCvP67uIwsXlb B+bojOTk6xifU5afuRLlhrlLIBcKixBa+Ipk7Tjg1HjVw+sql8GAwc/9j2QfrCeq TTweUO7ZuhOyyFfwjekVg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:date:feedback-id:feedback-id:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1673537935; x=1673624335; bh=0 fiGbaAtyZKHVVBpzzV+Tpqper1kzIwxK+JYysg3zK0=; b=Dn0IqiBn67tP3qXqb CoEZ4pIcUWnwyX5FXzymnQ4WptcqMKrmK0FuJJ1sgRz5SWbRc4f0dAw3lQRy9yS7 mmn1KC+rpKfrHTC3CLyZ6eqbPrenGEOrJ0wq0jLipqKW1W+kBMxBIWq5Boas3+7a fWVXoX+S+aXjEA/jVlNDadTJceQ7FzL587WhIN9VkS/X6O1e9Nnl0w3NM2LBkIz8 DyluqE1aaGOnLpaclHX0EYpmrQfsyZis6Jui8q17YXFv9bP5oMII2iSPjJ2zFWLT m4cy4twkjZkf/p7UczKU4LI5WTPUE/5fPx6XyjqAEsPYorV73gLzqGpKZQJIACPx nVDpQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrleeigdejlecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepkfffgggfuffvfhfhjggtgfesthekre dttdefjeenucfhrhhomheptegurhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhl rghvvghrsegrkhhlrghvvghrrdgtohhmqeenucggtffrrghtthgvrhhnpedugfeuleegve ffhfegleejhefhtedtgeeileeggfehfefffeevgeejtdeutefftdenucevlhhushhtvghr ufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvg hrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 12 Jan 2023 10:38:55 -0500 (EST) Message-ID: Date: Thu, 12 Jan 2023 07:38:54 -0800 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.6.1 Subject: Re: Changing displayed time zone in RAISE NOTICE output? To: Ron , pgsql-general References: <6b5f2616-f44a-10c5-974d-fc19cc493473@gmail.com> <0ccb4bf8-2f7f-7455-49ac-ff06cda36438@aklaver.com> <6a7ddac2-48e1-7339-5919-a69d6d7801ae@gmail.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: <6a7ddac2-48e1-7339-5919-a69d6d7801ae@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/11/23 21:25, Ron wrote: > On 1/11/23 15:06, Adrian Klaver wrote: > > Hmm.  I'd have sworn this didn't work when I tried it: Did you do?: DO $$ BEGIN RAISE NOTICE '%', clock_timestamp() at timezone 'UTC'; END$$; ERROR: syntax error at or near "timezone" LINE 3: RAISE NOTICE '%', clock_timestamp() at timezone 'UTC'; > > postgres=# > postgres=# DO $$ > BEGIN > RAISE NOTICE '%', clock_timestamp() at time zone 'UTC'; > END$$; > NOTICE:  2023-01-12 05:22:40.517299 > > But it does work, so all's well that ends well. > -- Adrian Klaver adrian.klaver@aklaver.com