*ahem*
You double-post a query *knowing* you shouldn't (otherwise why the
"sorry"?), compounding the error by not picking the right list at all. I
chide you for it privately, not to hide my actions but to keep
irrelevant traffic on the list down, and you then decide it's proper to
post my private reply publicly. I don't think you're in any position to
offer me lessons in netiquette.
cheers
andrew
Fred Janon wrote:
Looks like Andrew Dunstan didn't want to go public...
Fred
---------- Forwarded message ----------
From: *Fred Janon* <fja...@gmail.com <mailto:fja...@gmail.com>>
Date: Tue, Dec 15, 2009 at 10:03
Subject: Re: [HACKERS] pgAdmin III: timestamp displayed in what time zone?
To: Andrew Dunstan <and...@dunslane.net <mailto:and...@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.
Fred
On Tue, Dec 15, 2009 at 00:07, Andrew Dunstan <and...@dunslane.net
<mailto:and...@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* <fja...@gmail.com <mailto:fja...@gmail.com>
<mailto:fja...@gmail.com <mailto:fja...@gmail.com>>>
Date: Mon, Dec 14, 2009 at 19:04
Subject: pgAdmin III: timestamp displayed in what time zone?
To: pgsql-gene...@postgresql.org
<mailto:pgsql-gene...@postgresql.org>
<mailto:pgsql-gene...@postgresql.org
<mailto:pgsql-gene...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
