Postgres Pro
Downloads
Home   >   mailing lists

Question about timestamp with time zone - Mailing list pgsql-general

From Jan van der Weijde
Subject Question about timestamp with time zone
Date
Msg-id 4B9C73D1EB78FE4A81475AE8A553B3C607801E@exch-lei1.attachmate.com
Whole thread Raw
Responses Re: Question about timestamp with time zone  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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
 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Inherited tables vs UNION ALL views
Next
From: Tom Lane
Date:
Subject: Re: Question about timestamp with time zone