AT TIME ZONE: "convert"? - Mailing list pgsql-general

From David Garamond
Subject AT TIME ZONE: "convert"?
Date
Msg-id 418632DE.1020203@zara.6.isreserved.com
Whole thread Raw
Responses Re: AT TIME ZONE: "convert"?
List pgsql-general
The Postgres manual says:

The AT TIME ZONE construct allows conversions of time stamps to
different time zones.

I'd guess most people would think what's meant here is something like
"unit conversion", and that the timestamp value stays the same (much
like 2 feet becomes 24 inches when it's being "converted"). But:

# SELECT NOW() = NOW() AT TIME ZONE 'UTC';
  ?column?
----------
  f
(1 row)

--
dave

pgsql-general by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: oracle synchronization strategy
Next
From: David Garamond
Date:
Subject: Re: AT TIME ZONE: "convert"?