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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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