Re: Timestamp changes committed to HEAD - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Timestamp changes committed to HEAD
Date
Msg-id 42EEACAB.4000303@opencloud.com
Whole thread Raw
In response to Re: Timestamp changes committed to HEAD  ("emergency.shower@gmail.com" <emergency.shower@gmail.com>)
List pgsql-jdbc
emergency.shower@gmail.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

pgsql-jdbc by date:

Previous
From: "emergency.shower@gmail.com"
Date:
Subject: Re: Timestamp changes committed to HEAD
Next
From: Jasper Potts
Date:
Subject: Re: Select where id in (LARGE LIST) ?