Re: Time Zone Setting

[James G Wilkinson <jgw(at)alpinegeophysics(dot)com>]

Doh! Brain cramp! 

I have received a couple of replies to this effect.  So much for
looking at the correct table (i.e., B.6).  Odd though that some
of the values from Table B.4 work as well for
"SET TIMEZONE TO <timezone>."

Regards,

Jim

Michael Fuhr wrote:

On Fri, Jul 28, 2006 at 01:59:55PM -0700, James G Wilkinson wrote:
  

I just ran into a small mystery.  I am trying to set the time zone
during my session and here is what happens:
    

You can find the list of acceptable time zone names in Appendix B
of the documentation:

http://www.postgresql.org/docs/8.1/interactive/datetime-keywords.html#DATETIME-TIMEZONE-SET-TABLE

  

My default timezone is PDT for this time of year.
    

Try 'PST8PDT' or 'US/Pacific'.