Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group