Skip site navigation (1) Skip section navigation (2)

Re: Time Zone Setting

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: James G Wilkinson <jgw(at)alpinegeophysics(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Time Zone Setting
Date: 2006-07-28 22:20:34
Message-ID: 20060728222034.GA97961@winnie.fuhr.org (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-novice by date

Next:From: James G WilkinsonDate: 2006-07-28 22:36:05
Subject: Re: Time Zone Setting
Previous:From: James G WilkinsonDate: 2006-07-28 20:59:55
Subject: Time Zone Setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group