Oddity with time zones.

From: Steve Rogerson <steve(dot)pg(at)yewtc(dot)demon(dot)co(dot)uk>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Oddity with time zones.
Date: 2017-04-03 10:59:57
Message-ID: 08c6ad0e-5574-36fb-9f9d-9104bee7efef@yewtc.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2017-04-03 11:51:18 Re: Unexpected interval comparison
Previous Message Tom DalPozzo 2017-04-03 09:40:29 spin locks and starvation