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

Re: Issue when displaying TIMESTAMPTZ values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kasper Rönning <kasper(dot)ronning(at)reliabit(dot)fi>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Issue when displaying TIMESTAMPTZ values
Date: 2012-06-07 19:05:05
Message-ID: 11474.1339095905@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
=?ISO-8859-1?Q?Kasper_R=F6nning?= <kasper(dot)ronning(at)reliabit(dot)fi> writes:
> Thank you for the quick reply! I was completely unaware of the old time 
> zones of Helsinki! However I'm afraid that the behaviour of Postgresql 
> seems plain wrong to me. An example:

> SET TIME ZONE 'Europe/Helsinki';
> DROP TABLE IF EXISTS test1;
> CREATE TABLE test1 (ts TIMESTAMPTZ);
> INSERT INTO test1 VALUES ('0001-01-01 00:00:00');
> SELECT * FROM test1;
> --               ts
> -- ------------------------------
> --  0001-01-01 00:00:00+01:39:52

> Here I enter a timestamp in Helsinki time zone, and the query result is 
> different, even though the time zone is the same.

No, the query result is the same, it's just more fully specified.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Renji BabuDate: 2012-06-08 08:40:29
Subject: error in connecting to Postgresql 9.1
Previous:From: Kasper RönningDate: 2012-06-07 18:56:42
Subject: Re: Issue when displaying TIMESTAMPTZ values

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