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
