čt 12. 1. 2023 v 16:39 odesílatel Adrian Klaver <adrian.klaver@xxxxxxxxxxx> napsal:
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';
there should be space >>AT TIME ZONE<<
(2023-01-12 17:21:10) postgres=# DO $$
BEGIN
RAISE NOTICE '%', clock_timestamp() at time zone 'UTC';
END$$;
NOTICE: 2023-01-12 16:21:14.063256
DO
(2023-01-12 17:21:14) postgres=#
BEGIN
RAISE NOTICE '%', clock_timestamp() at time zone 'UTC';
END$$;
NOTICE: 2023-01-12 16:21:14.063256
DO
(2023-01-12 17:21:14) postgres=#
>
> 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@xxxxxxxxxxx
