On 18 December 2017 at 18:43, Thomas Kellerer <spam_ea...@gmx.net> wrote:
> > All of the timestamps in our system represent an instant in time, not > > a clock date/time, so timestamp with time zone is more appropriate. > > All of the data that is currently on disk in timestamp columns was > > inserted in a db session in UTC, and represents that timestamp in > > UTC. > > > Are you aware of the fact that "timestamp with time zone" does NOT > actually store the time zone? > Yes. > A timestamptz stores everything as UTC and the value is converted to the > session time zone upon retrieval. > Which is exactly what we want.
