Re: Time Zone Setting - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: Time Zone Setting
Date
Msg-id 20060728222034.GA97961@winnie.fuhr.org
Whole thread Raw
In response to Time Zone Setting  (James G Wilkinson <jgw@alpinegeophysics.com>)
Responses Re: Time Zone Setting
List pgsql-novice
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'.

--
Michael Fuhr

pgsql-novice by date:

Previous
From: James G Wilkinson
Date:
Subject: Time Zone Setting
Next
From: James G Wilkinson
Date:
Subject: Re: Time Zone Setting