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 server's timezone?
3) a value in a common frame of reference (GMT/UTC)?
4) any value with an explicit timezone?
And how should a time or timestamp value returned by the server
be interpreted in the client interface?
And how does this all depend on the timezone setting of the
server?
Regards,
René Pijlman <rene@lab.applinet.nl>