Re: Java 8 OffsetDateTime clarification

David Wall schrieb am 07.05.2019 um 04:31:
> This seems incorrect to me.  
> The backend, when using TIMESTAMP WITH TIME ZONE, stores the date+time+tzoffset

No, it does not.

From https://www.postgresql.org/docs/current/datatype-datetime.html

> For timestamp with time zone, the internally stored value is always
> in UTC (Universal Coordinated Time, traditionally known as Greenwich
> Mean Time, GMT). An input value that has an explicit time zone
> specified is converted to UTC using the appropriate offset for that
> time zone. If no time zone is stated in the input string, then it is
> assumed to be in the time zone indicated by the system's TimeZone
> parameter, and is converted to UTC using the offset for the timezone
> zone.
> 
> When a timestamp with time zone value is output, it is always
> converted from UTC to the current timezone zone, and displayed as
> local time in that zone