Re: When exactly is a TIMESTAMPTZ converted to the sessions time zone?

2018-08-09 Thread Paul Jungwirth
On 08/09/2018 01:49 PM, Bruce Momjian wrote: On Tue, Jul 3, 2018 at 05:00:17PM -0400, Tom Lane wrote: Thomas Kellerer writes: A recent discussion around timestamptz behaviour has lead me to question my own understanding on how a TIMESTAMPTZ is converted to the session's time zone. I assumed

Re: When exactly is a TIMESTAMPTZ converted to the sessions time zone?

2018-08-09 Thread Bruce Momjian
On Tue, Jul 3, 2018 at 05:00:17PM -0400, Tom Lane wrote: > Thomas Kellerer writes: > > A recent discussion around timestamptz behaviour has lead me to question my > > own understanding on how a TIMESTAMPTZ is converted to the session's time > > zone. > > I assumed this conversion happens *on

Re: When exactly is a TIMESTAMPTZ converted to the sessions time zone?

2018-07-03 Thread Tom Lane
Thomas Kellerer writes: > A recent discussion around timestamptz behaviour has lead me to question my > own understanding on how a TIMESTAMPTZ is converted to the session's time > zone. > I assumed this conversion happens *on the server* before the value is sent to > the client. It's done in

When exactly is a TIMESTAMPTZ converted to the sessions time zone?

2018-07-03 Thread Thomas Kellerer
A recent discussion around timestamptz behaviour has lead me to question my own understanding on how a TIMESTAMPTZ is converted to the session's time zone. I assumed this conversion happens *on the server* before the value is sent to the client. A co-worker of mine claims that this is purely