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

Re: Time Zone Setting

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

In response to

pgsql-novice by date

Next:From: CoreyDate: 2006-07-28 23:26:24
Subject: number of rows returned from SELECT
Previous:From: Michael FuhrDate: 2006-07-28 22:20:34
Subject: Re: Time Zone Setting

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