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?
In response to
pgsql-jdbc by date
|Next:||From: Kris Jurka||Date: 2008-10-27 23:15:59|
|Subject: Re: Unexpected value in Time object|
|Previous:||From: John||Date: 2008-10-25 20:24:29|
|Subject: Re: Connection hanging on INSERT apparently due to large batch size and 4 CPU cores|