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/