čt 12. 1. 2023 v 17:27 odesílatel Adrian Klaver
napsal:
> On 1/12/23 08:22, Pavel Stehule wrote:
> >
> >
> > čt 12. 1. 2023 v 16:39 odesílatel Adrian Klaver
> > mailto:adrian.kla...@aklaver.com>> napsal:
> >
> > On 1/11/23 21:25, Ron wrote:
> > > On 1/11/23 15:06, Adrian Klaver wrote:
>
On 1/12/23 08:22, Pavel Stehule wrote:
čt 12. 1. 2023 v 16:39 odesílatel Adrian Klaver
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
čt 12. 1. 2023 v 16:39 odesílatel Adrian Klaver
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$$;
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 '%',
On 1/11/23 15:06, Adrian Klaver wrote:
On 1/11/23 13:00, Ron wrote:
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
On 1/11/23 13:00, Ron wrote:
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 '%',
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$$;