=?ISO-8859-1?Q?Kasper_R=F6nning?= <kasper.ronn...@reliabit.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs