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

Re: Timestamp with Timezone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Chris M(dot) Gamble" <chris(dot)gamble(at)cpbinc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp with Timezone
Date: 2004-08-25 20:06:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
"Chris M. Gamble" <chris(dot)gamble(at)cpbinc(dot)com> writes:
> I checked on the old server, and found that in the postgresql.conf,
> the timezone was set for unknown.

Which would mean "use the system-wide timezone setting".  I suspect you
have the new server configured with a different system-wide setting.

			regards, tom lane

In response to

pgsql-general by date

Next:From: Scott GerhardtDate: 2004-08-25 22:02:49
Subject: Aggregate query for multiple records
Previous:From: Ennio-SrDate: 2004-08-25 19:52:26
Subject: Re: update table from internet site

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