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