| 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: | Whole Thread | Raw Message | 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 |