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 1pFiJ3-0006KA-LT for pgsql-general@arkaria.postgresql.org; Wed, 11 Jan 2023 21:06:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pFiJ2-0004vC-E1 for pgsql-general@arkaria.postgresql.org; Wed, 11 Jan 2023 21:06:44 +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 1pFiJ1-0004tc-8r for pgsql-general@lists.postgresql.org; Wed, 11 Jan 2023 21:06:44 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pFiIy-00034h-6Q for pgsql-general@lists.postgresql.org; Wed, 11 Jan 2023 21:06:42 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id D394D5C00CF; Wed, 11 Jan 2023 16:06:37 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Wed, 11 Jan 2023 16:06:37 -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=1673471197; x= 1673557597; bh=b4gOEzQ4S6Rj7r2GBOVJJGJLOEHOXDryAHXiFXB7jC8=; b=G akb07tPFKcIreLfQ2juyNshhat6Z5sW+4z6kIlU8q2v4LSsh17A8DR4Iffob8SZ1 /+qujtZApDZApPDk+KRAEbsNrqD63dvGOqK3HXWM5K2tMzbjooOkNXQFl9PdxCIK LigfbfG0euQ3csAOj/dKXOBMbsc9OlrGLQMD+W92DILlABH04GHBjY2LXB2FWtyl cqTkZLbtmdlMIKyUhRlz+tYmRx3TvRImvDpcelD+mPaObEsz2jt4E9uUQBpa+oow J29KQlT1/Zw01pmGO114PKuiGmPxbgBYyevxE+C1XVkisZHk1Tl52H2m14uPeA6p zW1tYMsHSHtSY9LvLhfBA== 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=1673471197; x=1673557597; bh=b 4gOEzQ4S6Rj7r2GBOVJJGJLOEHOXDryAHXiFXB7jC8=; b=nvWUsys7LMiHmA9tV rO2E4kZoYKd35cU63dfUYxCU+/XGKyj5IZM+ablXnjC6i25H5259YH0uQinZ4kRi QiTqGFSHki8L8vHi3sW4jkXiyfCjpFs5/zOAlLR5iTQmsTKi2/UwWMNZrlpC5l5I JoonnUMVhSi40cIpTPXs4xwVYkpDSHa9l6L0si3fqES3+7IpNbWXrDZ4g9ppcqP7 4Ftftn9hB2WTPMFiM51qkYu78rAjEolJjSwzLHelKKMFEG8dQFVSQIj8kSFq8dYV GBPeT28rQhONAnTt+U/JieGhDBTXgNor2qBCU7OMVTNStzKbeHZIVl1/8KrgBpFd bkeHg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrleeggddugeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefkffggfgfuvfhfhfgjtgfgsehtke ertddtfeejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhk lhgrvhgvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepudfgueelge evfffhgeeljeehhfettdegieelgefgheefffefveegjedtueetffdtnecuvehluhhsthgv rhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvh gvrhesrghklhgrvhgvrhdrtghomh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 11 Jan 2023 16:06:37 -0500 (EST) Message-ID: <0ccb4bf8-2f7f-7455-49ac-ff06cda36438@aklaver.com> Date: Wed, 11 Jan 2023 13:06:36 -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> Content-Language: en-US From: Adrian Klaver In-Reply-To: <6b5f2616-f44a-10c5-974d-fc19cc493473@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 13:00, Ron wrote: > How do I get clock_timestamp() to display the time in a different time > zone? > > This is America/Chicago, but I'd like to display it in a different TZ. > > psql (12.12 (Ubuntu 12.12-1.pgdg18.04+1)) > postgres=# DO $$ > postgres$# BEGIN > postgres$# RAISE NOTICE '%', clock_timestamp(); > postgres$# END$$; > NOTICE:  2023-01-11 14:52:34.408225-06 > DO > test(5432)=# select clock_timestamp(); clock_timestamp -------------------------------- 01/11/2023 13:05:54.646178 PST (1 row) test(5432)=# select clock_timestamp() at time zone 'UTC'; timezone ---------------------------- 01/11/2023 21:06:04.742478 -- Adrian Klaver adrian.klaver@aklaver.com