Re: Unexpected value in Time object

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