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.kla...@aklaver.com
