Re: Timestamp with time zone

Michael Glaesemann <grzm@seespotcode.net> wrote:

>>  IMVHO best practice is to treat TIMESTAMP WITH TIME ZONE
>> as truly evil (TM),

> Um, why?

Because its in- and output depend on:

- The time zone set in the server's OS configuration,
- the time zone set in the server's PostgreSQL configura-
  tion,
- the time zone set in the user's configuration,
- a possible "SET SESSION" command,
- a possible "SET LOCAL" command and
- a possible "AT TIME ZONE" construct.

Add to that the possibility that the zoneinfo data might
differ from server to server and over time.

  So unless you are /very/ certain that all servers, all us-
ers and all clients will use the same settings always and
forever, especially if clients exchange data outside the da-
tabase, I'd recommend avoiding "WITH TIME ZONE" whenever
possible.

Tim