# 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 TIME ZONE 'UTC';
timezone
-------------------------------
2017-04-03 11:57:14.088515+01
(1 row)
This makes no sense to me.
Steve