Re: Odd timezone backend output

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/