Re: [GENERAL] Oddity with time zones.

2017-04-03 Thread Tom Lane
Steve Rogerson writes: > # select (now()); > now > --- > 2017-04-03 11:57:09.891043+01 > (1 row) > sjr_local1db=# select (now() AT TIME ZONE 'UTC'); > timezone > > 2017-04-03 10:57:11.714571 > (1 row) > sjr_local

[GENERAL] Oddity with time zones.

2017-04-03 Thread Steve Rogerson
# select (now()); now --- 2017-04-03 11:57:09.891043+01 (1 row) sjr_local1db=# select (now() AT TIME ZONE 'UTC'); timezone 2017-04-03 10:57:11.714571 (1 row) sjr_local1db=# select (now() AT TIME ZONE 'UTC') AT TI