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
Amsterdam Time that is UTC + 20. So that more or less explains the
+00:19 that is returned.
However what I don't understand is that there is also a
'second-correction' of 32 in the timestamp value that is not returned in
the time zone.
I guess the returned values should have been '1903-08-06
22:19:32+00:19:32'. But because the time zone specification does not
allow seconds I would expect '1903-08-06 22:19:00+00:19'
Can anyone explain this?
Thanks for any help!
Regards,
Jan