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 [EMAIL PROTECTED] +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
