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 -- Born in Arizona, moved to Babylonia.
