| From: | Thomas Lockhart <lockhart(at)fourpalms(dot)org> |
|---|---|
| To: | Barry Lind <barry(at)xythos(dot)com> |
| Cc: | "Winter, Wolfgang" <Wolfgang(dot)Winter(at)AtosOrigin(dot)com>, pgsql-jdbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timezone incompatibility |
| Date: | 2002-06-22 05:27:24 |
| Message-ID: | 3D140ABC.A9ED531F@fourpalms.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
Barry Lind wrote:
>
> OK, I found the bug in the jdbc code. It was treating a date coming
> from the server without timezone information as being in the local
> timezone instead of being in GMT. I will fix this over the weekend.
For "timestamptz" aka TIMESTAMP WITH TIME ZONE if it doesn't have a time
zone then it is GMT. If it is "timestamp" aka TIMESTAMP WITHOUT TIME
ZONE then they all are in the local time zone.
Does the JDBC driver let you distinguish between all of the cases?
- Thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2002-06-22 07:48:23 | Re: [GENERAL] Idea for the statistics collector |
| Previous Message | Barry Lind | 2002-06-22 03:46:09 | Re: timezone incompatibility |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | w.winter | 2002-06-22 08:49:56 | Re: timezone incompatibility |
| Previous Message | Barry Lind | 2002-06-22 03:46:09 | Re: timezone incompatibility |