čt 12. 1. 2023 v 17:27 odesílatel Adrian Klaver <adrian.kla...@aklaver.com> napsal:
> 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 > >
