Oddity with time zones. - Mailing list pgsql-general

From Steve Rogerson
Subject Oddity with time zones.
Date
Msg-id 08c6ad0e-5574-36fb-9f9d-9104bee7efef@yewtc.demon.co.uk
Whole thread Raw
List pgsql-general
# 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


pgsql-general by date:

Previous
From: Tom DalPozzo
Date:
Subject: spin locks and starvation
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Unexpected interval comparison