Re: Fwd: pgAdmin III: timestamp displayed in what time zone? - Mailing list pgsql-hackers

*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* <fjanon@gmail.com <mailto: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 <mailto: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.
>
> Fred
>
>
> On Tue, Dec 15, 2009 at 00:07, Andrew Dunstan <andrew@dunslane.net 
> <mailto: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>
>         <mailto: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>
>         <mailto: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
>
>
>