Re: TimestampUtils.toJavaSecs / toPgSecs seem dubious

On 26.07.19 14:59, Chapman Flack wrote:
> pgJDBC's toJavaSecs() and toPgSecs() methods contain some dubious
> adjustments, apparently there in an attempt to make the java.sql
> mapping less weird. But it really succeeds only in smearing the weird
> around so it's not where it belongs, and some even gets on the java.time
> mapping, which ought to be free of weird.

So, I had a look at this. I can only reproduce it with the binary 
protocol, not with the text protocol. So as a short term work around 
switching to the text protocol should work.
java.time inherits the weird because it also goes through toJavaSecs. I 
am working on a patch but it needs more tests and polish. I hope I'll be 
able to submit a bug and PR shortly.

Cheers
Philippe