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

Re: Unexpected value in Time object

From: Kris Jurka <books(at)ejurka(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: John Pile <john(at)pile(dot)us>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Unexpected value in Time object
Date: 2008-10-27 23:15:59
Message-ID: Pine.BSO.4.64.0810271914340.12079@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

On Tue, 28 Oct 2008, Oliver Jowett wrote:

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

The attached test case shows the results of trying to store a Time object 
with one millisecond in a timetz field with a America/Los_Angelese JVM 
timezone.

Orig Time: 16:00:00
Orig TZ offset: 480
Orig millis: 1
Result as String: 16:00:00.001-08
Result Time: 16:00:00
Result TZ Offset: 480
Result millis: 86400001

Kris Jurka

Attachment: TimeTest.java
Description: text/plain (1.2 KB)

In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2008-10-27 23:50:55
Subject: Re: Unexpected value in Time object
Previous:From: Oliver JowettDate: 2008-10-27 20:56:27
Subject: Re: Unexpected value in Time object

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