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