AT TIME ZONE: "convert"?

From: David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: AT TIME ZONE: "convert"?
Date: 2004-11-01 12:58:06
Message-ID: 418632DE.1020203@zara.6.isreserved.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-11-01 13:02:33 Re: AT TIME ZONE: "convert"?
Previous Message Joachim Wieland 2004-11-01 11:04:01 Re: oracle synchronization strategy