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.<br
/><br/>Thanks<br /><br />Fred<br /><br /><div class="gmail_quote">---------- ----------<br />From: <b
class="gmail_sendername">FredJanon</b> <span dir="ltr"><<a href="mailto:fjanon@gmail.com"
target="_blank">fjanon@gmail.com</a>></span><br/> Date: Mon, Dec 14, 2009 at 19:04<br />Subject: pgAdmin III:
timestampdisplayed in what time zone?<br />To: <a href="mailto:pgsql-general@postgresql.org"
target="_blank">pgsql-general@postgresql.org</a><br/><br /><br />Hi,<br /><br /> I am using Postgres 8.3. I have a
tabledefined like this:<br /><br />=======================<br />-- Table: timeson<br /><br />-- DROP TABLE timeson;<br
/><br/>CREATE TABLE timeson<br />(<br /> id bigint NOT NULL,<br /> enddatetime timestamp without time zone NOT
NULL,<br/> startdatetime timestamp without time zone NOT NULL,<br /> times_id bigint,<br /> CONSTRAINT timeson_pkey
PRIMARYKEY (id),<br /> CONSTRAINT fkb1af5ba5890cf3da FOREIGN KEY (times_id)<br /> REFERENCES times (id) MATCH
SIMPLE<br/> ON UPDATE NO ACTION ON DELETE NO ACTION<br />)<br />WITH (OIDS=FALSE);<br />ALTER TABLE timeson OWNER
TOmyfreo;<br /><br />======================<br />I populate the table with some data and use pgAdmin III 1.8.4 to view
thedate "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?<br /><br />Thanks<br
/><fontcolor="#888888"><br />Fred<br /></font></div><br />