From: | Rene Pijlman <rene(at)lab(dot)applinet(dot)nl> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Timezones and time/timestamp values in FE/BE protocol |
Date: | 2001-09-09 18:28:15 |
Message-ID: | kbbnpt0lf6iiom1jm42misb0mf3iol8287@4ax.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
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(at)lab(dot)applinet(dot)nl>
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-09-09 19:16:00 | Re: INHERIT |
Previous Message | Hannu Krosing | 2001-09-09 18:23:57 | Re: INHERIT |
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2001-09-09 19:51:10 | Re: [HACKERS] Troubles using German Umlauts with JDBC |
Previous Message | Rene Pijlman | 2001-09-09 14:46:30 | Re: [HACKERS] Troubles using German Umlauts with JDBC |