Re: Changing displayed time zone in RAISE NOTICE output?

[Adrian Klaver]

On 1/12/23 08:22, Pavel Stehule wrote:


čt 12. 1. 2023 v 16:39 odesílatel Adrian Klaver 
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> 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=#

Yeah I know, I was responding to Ron saying his previous attempt had 
failed. Using 'timezone' instead of 'time zone' is a mistake I have made 
often enough that I threw it out there as a possible cause for the failure.



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




--
Adrian Klaver
adrian.kla...@aklaver.com