pgAdmin III: timestamp displayed in what time zone?

From: Fred Janon <fjanon(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pgAdmin III: timestamp displayed in what time zone?
Date: 2009-12-14 13:50:26
Message-ID: 2fd0c7810912140550y1c8179a2ke3404931d6216bd4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgsql-general 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.

Thanks

Fred

---------- ----------
From: Fred Janon <fjanon(at)gmail(dot)com>
Date: Mon, Dec 14, 2009 at 19:04
Subject: pgAdmin III: timestamp displayed in what time zone?
To: pgsql-general(at)postgresql(dot)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

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2009-12-14 14:02:17 Re: unpleasant characters
Previous Message Dave Page 2009-12-14 12:44:30 Re: unpleasant characters

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-12-14 14:19:16 Re: getaddrinfo.c error
Previous Message Craig Ringer 2009-12-14 13:05:16 Re: Visibility of temporary database objects

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2009-12-14 13:59:30 Re: Crash on pg_ctl initdb without options
Previous Message Stephen Frost 2009-12-14 13:47:14 Re: Row-Level Security