|
Re: [GENERAL] timezone incompatibility: msg#00211db.postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx |
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | How can I stop a long running query: 00211, Angelo Misto' |
|---|---|
| Next by Date: | Re: servlets and JDBC (postgresql 7.2): 00211, Nookala Satish Kumar |
| Previous by Thread: | Re: [GENERAL] timezone incompatibilityi: 00211, Barry Lind |
| Next by Thread: | Re: timezone incompatibility: 00211, Thomas Lockhart |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
| News | FAQ | advertise |