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

Time Zone Setting

From: James G Wilkinson <jgw(at)alpinegeophysics(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Time Zone Setting
Date: 2006-07-28 20:59:55
Message-ID: 44CA7ACB.5070506@alpinegeophysics.com (view raw or flat)
Thread:
Lists: pgsql-novice
I just ran into a small mystery.  I am trying to set the time zone
during my session and here is what happens:

megan=# set timezone to 'EST'
megan=# do some work here
megan=# set timezone to 'PST'
ERROR:  unrecognized time zone name: "PST"
megan=# set timezone to 'PDT'
ERROR:  unrecognized time zone name: "PDT"
megan=# set timezone to 'MST'
megan=# set timezone to 'GMT'
megan=# select version();
                                                 version
--------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 
4.0.0 20050519 (Red Hat 4.0.0-8)

My default timezone is PDT for this time of year.

I am a bit mystified.  Any suggestions?

Regards,

Jim

Responses

pgsql-novice by date

Next:From: Michael FuhrDate: 2006-07-28 22:20:34
Subject: Re: Time Zone Setting
Previous:From: Andrew HammondDate: 2006-07-28 20:51:52
Subject: Re: Tables Locks Quetion or Strictlly subsequent numbers

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