Oddity with time zones.

Steve Rogerson <steve.pg@xxxxxxxxxxxxxxxxx> · Mon, 3 Apr 2017 11:59:57 +0100

# 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general