pgAdmin III: timestamp displayed in what time zone?
От | Fred Janon |
---|---|
Тема | pgAdmin III: timestamp displayed in what time zone? |
Дата | |
Msg-id | 2fd0c7810912140550y1c8179a2ke3404931d6216bd4@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: pgAdmin III: timestamp displayed in what time zone?
|
Список | pgsql-hackers |
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 />
В списке pgsql-hackers по дате отправления: