Re: Unexpected value in Time object - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Unexpected value in Time object
Date
Msg-id 49062AFB.6020406@opencloud.com
Whole thread Raw
In response to Unexpected value in Time object  ("John Pile" <john@pile.us>)
Responses Re: Unexpected value in Time object  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
John Pile wrote:

> I created a java.sql.Time object with an inner "fastTime" value of 1,
> storing it in a "time with time zone" field using a PreparedStatement
> insert.  When I retrieve it, also via PreparedStatement, I notice that
> the "fastTime" value is not the value 1 that I expected, but 86400001
> instead.  Although the toString() output looks the same for these two
> values, the check originalObject.equals(retrievedObject) returns false.

What is your JVM's default timezone?
What is the actual value stored in the DB?

-O

pgsql-jdbc by date:

Previous
From: John
Date:
Subject: Re: Connection hanging on INSERT apparently due to large batch size and 4 CPU cores
Next
From: Kris Jurka
Date:
Subject: Re: Unexpected value in Time object