Skip site navigation (1) Skip section navigation (2)

Fwd: pgAdmin III: timestamp displayed in what time zone?

From: Fred Janon <fjanon(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Fwd: pgAdmin III: timestamp displayed in what time zone?
Date: 2009-12-14 12:15:12
Message-ID: 2fd0c7810912140415t3041d354x1b73b6897f1eed86@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-generalpgsql-hackers
Sorry, I didn't know about this list...

---------- Forwarded message ----------
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

pgsql-hackers by date

Next:From: Bernd HelmleDate: 2009-12-14 12:19:27
Subject: Re: [patch] executor and slru dtrace probes
Previous:From: Dave PageDate: 2009-12-14 12:11:58
Subject: Re: Winflex

pgadmin-hackers by date

Next:From: Euler Taveira de OliveiraDate: 2009-12-14 12:35:52
Subject: unpleasant characters
Previous:From: Fred JanonDate: 2009-12-14 11:04:07
Subject: pgAdmin III: timestamp displayed in what time zone?

pgsql-general by date

Next:From: Phoenix KiulaDate: 2009-12-14 12:21:08
Subject: Re: How to remove non-UTF values from a table?
Previous:From: Fred JanonDate: 2009-12-14 11:04:07
Subject: pgAdmin III: timestamp displayed in what time zone?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group