On Fri, May 02, 2008 at 09:54:20AM -0400, Andrew Chernow wrote:
> I prefer offset from UTC, the timezone abbrevs are ambiguos and confusing.

So did you read the manual on SET TIME ZONE?

> TIME ZONE

> SET TIME ZONE value is an alias for SET timezone TO value. The
> syntax SET TIME ZONE allows special syntax for the time zone
> specification. Here are examples of valid values:

> 'PST8PDT'

> The time zone for Berkeley, California.
> 'Europe/Rome'

> The time zone for Italy.
> -7

> The time zone 7 hours west from UTC (equivalent to
> PDT). Positive values are east from UTC. INTERVAL '-08:00' HOUR
> TO MINUTE

> The time zone 8 hours west from UTC (equivalent to PST).

A

--
Andrew Sullivan
ajs@commandprompt.com
+1 503 667 4564 x104
http://www.commandprompt.com/

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