Re: [GENERAL] Question about timestamp with time zone

2006-09-14 Thread Tom Lane
"Jan van der Weijde" <[EMAIL PROTECTED]> writes: > When I insert a time stamp value '1903-08-07 00:00:00+02' into a table > and next select it again using psql I get '1903-08-06 22:19:32+00:19'. > I'm located in The Netherlands and before 1940 there was a so called > Amsterdam Time that is UTC + 20

[GENERAL] Question about timestamp with time zone

2006-09-14 Thread Jan van der Weijde
Hi All,   I have an issue with timestamp with time zone I don't understand.   When I insert a time stamp value '1903-08-07 00:00:00+02' into a table and next select it again using psql I get '1903-08-06 22:19:32+00:19'. I'm located in The Netherlands and before 1940 there was a so called Am