Re: Timestamp changes committed to HEAD

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: "emergency(dot)shower(at)gmail(dot)com" <emergency(dot)shower(at)gmail(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Timestamp changes committed to HEAD
Date: 2005-08-01 23:13:47
Message-ID: 42EEACAB.4000303@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

emergency(dot)shower(at)gmail(dot)com wrote:

> Everything seems to be OK, except that read operations from the
> America/St_Johns server lead to a deviation of minus half an hour,
> probably due to a rounding error in the driver's getTimestamp
> implementation.

Ok, it looks like there is another longstanding bug in TimestampUtils
that I didn't find: it just doesn't parse timezones with non-zero minute
offsets at all (there's code there that tries to do it, but it's incorrect)

I'll commit a fix to CVS shortly, once I've sorted out a test to go with it.

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jasper Potts 2005-08-02 09:23:27 Re: Select where id in (LARGE LIST) ?
Previous Message emergency.shower@gmail.com 2005-08-01 19:30:00 Re: Timestamp changes committed to HEAD