Re: Unexpected value in Time object

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: John Pile <john(at)pile(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Unexpected value in Time object
Date: 2008-10-27 20:56:27
Message-ID: 49062AFB.6020406@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2008-10-27 23:15:59 Re: Unexpected value in Time object
Previous Message John 2008-10-25 20:24:29 Re: Connection hanging on INSERT apparently due to large batch size and 4 CPU cores