Re: [HACKERS] Timezones and time/timestamp values in FE/BE protocol

2001-09-09 Thread Barry Lind
Rene, Since the FE/BE protocol deals only with string representations of values, the protocol doesn't have too much to do with it directly. It is what happens on the client and server sides that is important here. Under the covers the server stores all timestamp values as GMT. When a select

[HACKERS] Timezones and time/timestamp values in FE/BE protocol

2001-09-09 Thread Rene Pijlman
I'm working on a problem in the JDBC driver that's related to timezones. How does PostgreSQL handle timezones in the FE/BE protocol exactly? When a client sends a time or timestamp value to the server via the FE/BE protocol, should that be: 1) a value in the client's timezone? 2) a value in the