Fwd: pgAdmin III: timestamp displayed in what time zone?

Looks like Andrew Dunstan didn't want to go public...

Fred

---------- Forwarded message ----------
From: Fred Janon <fjanon(at)gmail(dot)com>
Date: Tue, Dec 15, 2009 at 10:03
Subject: Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?
To: Andrew Dunstan <andrew(at)dunslane(dot)net>

Thanks for being so polite. At least Greg Smith suggested the right list to
ask. I see that some people still know how to behave socially. BTW, this
list is the list listed in the pgadmin tips for tech questions.

Fred

On Tue, Dec 15, 2009 at 00:07, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:

>
> That's no excuse at all. Please keep queries like this OFF the -hackers
> list.
>
> cheers
>
> andrew
>
> Fred Janon wrote:
>
>> Sorry if if's a double post, but I thought that it would be more likely I
>> would get an answer on the hackers list.
>>
>> Thanks
>>
>> Fred
>>
>> ---------- ----------
>> From: *Fred Janon* <fjanon(at)gmail(dot)com <mailto:fjanon(at)gmail(dot)com>>
>>
>> Date: Mon, Dec 14, 2009 at 19:04
>> Subject: pgAdmin III: timestamp displayed in what time zone?
>> To: pgsql-general(at)postgresql(dot)org <mailto:pgsql-general(at)postgresql(dot)org>
>>
>>
>>
>> Hi,
>>
>> I am using Postgres 8.3. I have a table defined like this:
>>
>> =======================
>> -- Table: timeson
>>
>> -- DROP TABLE timeson;
>>
>> CREATE TABLE timeson
>> (
>> id bigint NOT NULL,
>> enddatetime timestamp without time zone NOT NULL,
>> startdatetime timestamp without time zone NOT NULL,
>> times_id bigint,
>> CONSTRAINT timeson_pkey PRIMARY KEY (id),
>> CONSTRAINT fkb1af5ba5890cf3da FOREIGN KEY (times_id)
>> REFERENCES times (id) MATCH SIMPLE
>> ON UPDATE NO ACTION ON DELETE NO ACTION
>> )
>> WITH (OIDS=FALSE);
>> ALTER TABLE timeson OWNER TO myfreo;
>>
>> ======================
>> I populate the table with some data and use pgAdmin III 1.8.4 to view the
>> date "View date> first top100 rows". the question is: in what timezone are
>> the fields showed in pgAdmin? no timezone (as stored), the server time zone
>> or the time zone of the computer where pgAdmin runs?
>>
>> Thanks
>>
>> Fred
>>
>>