Looks like Andrew Dunstan didn't want to go public...
Fred
---------- Forwarded message ----------
From:
Fred Janon <fjanon@gmail.com> Date: Tue, Dec 15, 2009 at 10:03
Subject: Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?
To: Andrew Dunstan <
andrew@dunslane.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.
FredOn Tue, Dec 15, 2009 at 00:07, Andrew Dunstan
<andrew@dunslane.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@gmail.com <mailto:fjanon@gmail.com>>
Date: Mon, Dec 14, 2009 at 19:04
Subject: pgAdmin III: timestamp displayed in what time zone?
To: pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.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